/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 vote232 views2 answers
Count items in a model django rest
Python Django
3 votes236 views1 answer
File manage py line 17 from exc django
Python Django
0 vote244 views1 answer
Manage.py startapp not working in django
Python Django
0 vote258 views1 answer
Django pass list of fields to values
Python Django
0 vote235 views1 answer
Django listview
Python Django
0 vote251 views1 answer
Using claudinary in django
Python Django
0 vote227 views1 answer
Creating base models django
Python Django
2 votes244 views2 answers
What is role of ALLOWED_HOSTs in Django
Python Django
0 vote248 views1 answer
Django model plural
Python Django
0 vote305 views1 answer
Django admin.py all fields
Python Django