/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 vote294 views1 answer
Django ModelChoiceField value not id
Python Django
0 vote233 views1 answer
Delete file in django terminal
Python Django
1 vote224 views1 answer
Django filter after annotate
Python Django
2 votes210 views1 answer
Django group with permission
Python Django
4 votes233 views2 answers
Arrayfield django example
Python Django
-1 vote217 views3 answers
Raw sql query to django converter
Python Django
29 votes385 views3 answers
Django admin create project
Python Django
0 vote220 views1 answer
Get full detail inside of id in django rest framework many to many
Python Django
3 votes266 views2 answers
Django radio button
Python Django
0 vote204 views2 answers
Check anonim user django
Python Django