/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 vote259 views1 answer
Values django
Python Django
0 vote325 views1 answer
Django import settings variables
Python Django
0 vote237 views1 answer
Django builtin signals
Python Django
0 vote265 views1 answer
Django auto increment field
Python Django
1 vote224 views1 answer
Django integer field example
Python Django
6 votes338 views4 answers
Media django
Python Django
0 vote238 views3 answers
Removing duplicates from django models data
Python Django
1 vote259 views1 answer
Django urlpattern
Python Django
0 vote243 views1 answer
Aes in django
Python Django
1 vote252 views5 answers
How to install django in virtual environment in ubuntu
Python Django