/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 vote347 views1 answer
Django.core.exceptions.ImproperlyConfigured: Application labels aren't unique, duplicates: auth
Python Django
1 vote378 views2 answers
Django print query
Python Django
0 vote380 views1 answer
Django import Response
Python Django
0 vote381 views1 answer
How to log errors while debug is false in django
Python Django
29 votes501 views5 answers
Static dirs django
Python Django
13 votes403 views2 answers
Delete database entry using name django
Python Django
0 vote365 views1 answer
Django check user admin
Python Django
1 vote350 views1 answer
Django urlpattern
Python Django
0 vote385 views1 answer
Django data from many to many field in template
Python Django
0 vote389 views1 answer
Django staff_member_required decorator
Python Django