/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

0 vote354 views1 answer
How to get SITE_ID in django....shell
Python Django
0 vote270 views1 answer
Get data from model with field name in django
Python Django
0 vote263 views1 answer
Delete all historical data django simple history
Python Django
0 vote306 views1 answer
Django serialize a get object is not iterable
Python Django
0 vote307 views1 answer
Template tag django
Python Django
7 votes291 views4 answers
From django.contrib import messages
Python Django
4 votes322 views1 answer
Create or update django models
Python Django
1 vote301 views1 answer
Keep the user logged in even though user changes password django
Python Django
2 votes297 views1 answer
Django group with permission
Python Django
0 vote290 views1 answer
Django model custom field
Python Django