/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 vote262 views1 answer
Import status in django rest framework
Python Django
0 vote232 views1 answer
How to add column to heroku postgres in my django app
Python Django
-1 vote228 views2 answers
Django cleanup
Python Django
0 vote247 views1 answer
Get date only from datetimefiel django
Python Django
4 votes241 views3 answers
No such table: django_session
Python Django
1 vote248 views1 answer
Django filter not equal to
Python Django
0 vote223 views1 answer
Difference in django project view and app view
Python Django
2 votes211 views1 answer
Django register models
Python Django
1 vote230 views2 answers
Join two querysets django
Python Django
0 vote222 views1 answer
Check date on template django
Python Django