/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

4 votes253 views2 answers
Django template for range
Python Django
5 votes269 views2 answers
Get_object_or_404 django
Python Django
0 vote273 views1 answer
How to pass primary key to url django
Python Django
8 votes243 views2 answers
Django create empty migration
Python Django
0 vote261 views1 answer
Django import settings variables
Python Django
0 vote243 views2 answers
Createview django
Python Django
1 vote253 views1 answer
Radiobuttons django
Python Django
0 vote285 views1 answer
Field 'id' expected a number but got <django.db.models.fields.related_descriptors.create_forward_many_to_many_manager.<locals>.ManyRelatedManager object at 0x7fb02044de80>
Python Django
0 vote249 views1 answer
How to store a int value in django sessions
Python Django
0 vote250 views1 answer
Listing of django model types
Python Django