/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

10 votes423 views3 answers
Django make migrations
Python Django
0 vote361 views1 answer
Create django model field based on another field
Python Django
1 vote404 views1 answer
Add search field to django admin
Python Django
1 vote367 views1 answer
Pip install django celery results
Python Django
3 votes402 views1 answer
Disable csrf for one url django
Python Django
6 votes394 views1 answer
How to create migrations in django
Python Django
0 vote378 views1 answer
Basic get method in class based view django
Python Django
0 vote381 views1 answer
Date format django template filter
Python Django
0 vote390 views1 answer
Python django model range validation
Python Django
0 vote448 views1 answer
How to deploy to heroku djangorest framework app
Python Django