/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

3 votes154 views2 answers
Django timezone india
Python Django
11 votes168 views3 answers
Django q filter
Python Django
5 votes156 views4 answers
Import user in django
Python Django
1 vote144 views1 answer
Django filter text first character upper case
Python Django
0 vote150 views1 answer
Django admin required decorator
Python Django
0 vote180 views3 answers
How to create a sub project in django
Python Django
3 votes151 views3 answers
Simple jwt django
Python Django
1 vote167 views2 answers
Redirect to the same page django
Python Django
30 votes253 views3 answers
Django createsuperuser
Python Django
0 vote141 views1 answer
How to customize simplejwt error response message in django restframework
Python Django