/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 vote233 views4 answers
Pip django graphql
Python Django
0 vote258 views1 answer
Django sign up
Python Django
0 vote265 views1 answer
Django swagger settings https
Python Django
0 vote282 views1 answer
Django insert bulk data
Python Django
0 vote271 views1 answer
Merge two Querysets in Python Django while preserving Queryset methods
Python Django
1 vote293 views1 answer
How to add captcha in django forms
Python Django
4 votes242 views4 answers
How to change django admin text
Python Django
-1 vote278 views1 answer
Cannot import name 'httpresponse' from 'django.http'
Python Django
28 votes312 views3 answers
Django abstractuser
Python Django
0 vote245 views1 answer
Import CreateAPIView django
Python Django