/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

15 votes386 views4 answers
Q django
Python Django
1 vote374 views1 answer
Cookies in django
Python Django
2 votes401 views1 answer
How to save bulk create in django
Python Django
0 vote349 views1 answer
Django blog new post
Python Django
0 vote388 views1 answer
Difference between __gte and __lte in Django
Python Django
0 vote342 views1 answer
Django get latest object
Python Django
1 vote316 views1 answer
Django template decimal places
Python Django
0 vote379 views2 answers
How to use django-filters with viewset
Python Django
0 vote398 views1 answer
Django tempalte tag datetime to timestamp
Python Django
0 vote354 views1 answer
Dockerize django app
Python Django