/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 vote195 views2 answers
Django template date format yyyy-mm-dd
Python Django
0 vote186 views1 answer
Django file field from base64
Python Django
0 vote196 views1 answer
Django staff_member_required decorator
Python Django
0 vote203 views1 answer
Django rest framework not getting form
Python Django
0 vote170 views1 answer
Register template tag django
Python Django
1 vote197 views1 answer
How to get a hyperlink in django
Python Django
1 vote222 views1 answer
Django gmail smtp
Python Django
0 vote237 views1 answer
"detail": "Method \"POST\" not allowed." django
Python Django
2 votes205 views2 answers
Django-admin command not found
Python Django
2 votes211 views1 answer
Django override delete
Python Django