How to get count of more than one field from a table using Django queryset

Question

here is my queryset

queryset = (PrathamTeamMembers.objects.
        select_related('state', 'district', 'block', 'personnel_type').
        filter(is_active=1).
        annotate(total_state=Count('state', distinct=True),
                 total_district=Count('district', distinct=True)))

I am expecting result similar to

{
 "total_state": 10
 "total_district": 60
}

But it is not aggregating instead it is grouping by table PrathamTeamMembers primary key. which I want to avoid. Since it is grouping on table primary key so my queryset giving result simlary to ..

[{
  "total_state": 1,
  "total_district": 1
},
{
  "total_state": 1,
  "total_district": 1
},
{
  "total_state": 1,
  "total_district": 1
}
]

If you want aggregations for the same table you need to use the `aggregate` method instead of `annotate`. — Abdul Aziz Barkat, May 17 '22 at 05:12
My bad. totally forgot to use aggregate method. It's working now. — Raju Singh, May 17 '22 at 05:53
Does this answer your question? [Django ORM remove unwanted Group by when annotate multiple aggregate columns](https://stackoverflow.com/questions/63391064/django-orm-remove-unwanted-group-by-when-annotate-multiple-aggregate-columns) — Abdul Aziz Barkat, May 17 '22 at 06:17

score 0 · Answer 1 · answered Sep 22 '22 at 08:19

use this link for help. GROUB BY ... COUNT/SUM Django ORM equivalent

https://riptutorial.com/django/example/30595/groub-by-----count-sum-django-orm-equivalent

We can perform a GROUP BY ... COUNT or a GROUP BY ... SUM SQL equivalent queries on Django ORM, with the use of annotate(), values(), order_by() and the django.db.models's Count and Sum methods respectfully:

How to get count of more than one field from a table using Django queryset

1 Answers1