/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 vote205 views1 answer
Django model make the field caseinsensitive
Python Django
0 vote192 views1 answer
Get last save id django model
Python Django
0 vote186 views1 answer
Django datepicker mindate and maxdate
Python Django
2 votes135 views2 answers
Django admin actions
Python Django
1 vote203 views1 answer
For loop django template count
Python Django
0 vote183 views1 answer
Query first 5 element in django
Python Django
0 vote181 views1 answer
Access host database django docker
Python Django
0 vote178 views1 answer
Django admin required decorator
Python Django
0 vote187 views2 answers
From django.core.management import execute_from_command_line ImportError: No module named django.core.management
Python Django
0 vote174 views1 answer
User passes test django
Python Django