/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 vote327 views2 answers
How to use django-filters with viewset
Python Django
0 vote296 views1 answer
Reverse relationship in django for one to one field for usage in Django rest serializer
Python Django
0 vote314 views1 answer
Django post request 403 forbidden
Python Django
0 vote320 views1 answer
Django.com
Python Django
0 vote301 views1 answer
Run django using nssm
Python Django
0 vote311 views1 answer
"DjangoJSONEncoder" is not defined
Python Django
4 votes302 views1 answer
Django forms set class
Python Django
9 votes315 views2 answers
Django model form import
Python Django
2 votes282 views2 answers
Search in django
Python Django
1 vote350 views1 answer
How to run the server in django
Python Django