/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 vote302 views1 answer
Make column nullable django
Python Django
0 vote386 views1 answer
Show post id on django admin interface
Python Django
15 votes419 views4 answers
Django python install
Python Django
4 votes349 views2 answers
Arrayfield django example
Python Django
5 votes397 views1 answer
Q is not defined pylance django
Python Django
0 vote385 views1 answer
Dynamic footer in django
Python Django
0 vote414 views1 answer
Unique mark boolean django model field
Python Django
0 vote397 views1 answer
How to create superuser in django heroku
Python Django
0 vote408 views1 answer
Django refresh form db
Python Django
1 vote408 views1 answer
Django get form id from request
Python Django