/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 vote167 views1 answer
Django sign up
Python Django
0 vote185 views1 answer
How to extract field values in list from queryset in django
Python Django
0 vote183 views1 answer
Settings.debug django
Python Django
0 vote171 views1 answer
AttributeError: module 'django.db.models' has no attribute 'ArrayField'
Python Django
0 vote177 views1 answer
Check date on template django
Python Django
0 vote167 views1 answer
Get data from model with field name in django
Python Django
0 vote172 views1 answer
Django extract array from post matrix
Python Django
1 vote179 views1 answer
What is values_list in django orm
Python Django
0 vote164 views1 answer
Django order by foreign key count
Python Django
3 votes115 views2 answers
Django favicon
Python Django