/Python/Django/Django orm group by month and year

Django orm group by month and year

print([v for v in
       Request.objects.annotate(month=ExtractMonth('date_creation'),
                                year=ExtractYear('date_creation'),)
                      .order_by()
                      .values('month', 'year')
                      .annotate(total=Count('*'))
                      .values('month', 'year', 'total')
       ])

Source: stackoverflow.com

Similar codes

1 vote232 views2 answers
How to get user id django
Python Django
3 votes242 views1 answer
Django import model from another app
Python Django
0 vote281 views1 answer
Aggregation with f() in django rest api
Python Django
8 votes249 views3 answers
Django sort queryset
Python Django
4 votes250 views5 answers
Module 'datetime' has no attribute 'now' django
Python Django
1 vote247 views2 answers
Django timezone settings
Python Django
2 votes233 views1 answer
Django.core.exceptions.ImproperlyConfigured: WSGI application 'souroSANOU.wsgi.application' could not be loaded; Error importing module.
Python Django
-1 vote236 views1 answer
Raw query in django
Python Django
0 vote256 views1 answer
Difference between __gte and __lte in Django
Python Django
0 vote239 views1 answer
Django bootstrap
Python Django