/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 vote136 views2 answers
Runserver coomand in django
Python Django
0 vote139 views1 answer
Django content type for model
Python Django
0 vote131 views1 answer
Django set random password
Python Django
0 vote159 views1 answer
Aggregation with f() in django rest api
Python Django
2 votes152 views2 answers
Django request.data
Python Django
0 vote128 views1 answer
Django month name from month number
Python Django
0 vote138 views1 answer
Initial TypedMultipleChoiceField django
Python Django
5 votes168 views2 answers
My django template doesnt want to load the static file
Python Django
0 vote173 views1 answer
Limit characters in django template
Python Django
0 vote129 views1 answer
Django template limit string length
Python Django