Report: Live animal count by cohort

[CraigJZ]

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 cohort 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)

[josephinef9]

claiming :)

[CraigJZ]

Thanks @josephinef9!!

[josephinef9]

@CraigJZ here is the screenshot of the query for live animals by cohort with the bar graph. Let me know your thoughts. No new seed data was needted!

[CraigJZ]

@josephinef9 This looks great!

[CraigJZ]

Added this query to the staging app. 🎉