- Subgroups are also included in the calculation
- Remove ActiveRecord calls from the view
- Extract calculations to a separate class
- Combine count queries into one