/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 vote218 views1 answer
How to add captcha in django forms
Python Django
1 vote187 views1 answer
Django don't redirect on submission
Python Django
23 votes243 views3 answers
Pip install django rest framework
Python Django
1 vote182 views1 answer
Django foreign key field on delete do nothing
Python Django
0 vote193 views1 answer
Django rest framework not getting form
Python Django
1 vote185 views1 answer
Get csrf_token value in django template
Python Django
0 vote194 views1 answer
How to console log in django heroku
Python Django
10 votes181 views2 answers
Django delete object
Python Django
2 votes194 views1 answer
Database default code in settings django
Python Django
0 vote209 views1 answer
Django check user admin
Python Django