/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 vote213 views1 answer
Unsupported media type django
Python Django
-1 vote200 views1 answer
Django template filter
Python Django
5 votes196 views4 answers
Import user in django
Python Django
1 vote230 views1 answer
Django genericforeignkey null
Python Django
1 vote201 views1 answer
Error popup in django not visible
Python Django
0 vote196 views1 answer
Input function in django
Python Django
1 vote239 views1 answer
Check if queryset is empty django template
Python Django
2 votes195 views5 answers
Django documentation
Python Django
7 votes201 views3 answers
How to display data in ascending order in django
Python Django
3 votes190 views3 answers
Simple jwt django
Python Django