rubyforgood/abalone

Report: Live animal count by facility

Closed this issue · 4 comments

CraigJZ commented

This report should be created in the staging app, under the White Abalone organization. The existing query that returns ALL animals by cohort can be used as a guide.

SELECT name, COUNT(*) FROM cohorts INNER JOIN animals on animals.cohort_id = cohorts.id GROUP BY cohorts.id

  • Create a query to track live animal counts by facility and display as a bar graph
  • Update seed data so the relevant data will be available to this query
  • Comment on this issue with a screen shot of the completed report

Depends on #715 (making mortality available to Blazer queries)

web-kat commented

Hey @CraigJZ, Darren has been out the past two days. I added the report to the staging environment here.

Here is a screenshot of the report. I don't believe we will need to update the seed data for this report, but let me know if you would like to see any changes!

animal-count-by-facility

CraigJZ commented

Thanks @web-kat!! I think the only change we will need for this one is to scope it to only include live animals. #791 has a similar scoping on cohorts that may be a useful reference for this.

  • 👍1
web-kat commented

@CraigJZ good call out. Updated in staging!

live-animal-count-by-facility

  • 🎉1
CraigJZ commented

@web-kat This looks great!! Thank you!!