/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 vote230 views1 answer
Django tempalte tag datetime to timestamp
Python Django
3 votes217 views2 answers
Django change user password
Python Django
9 votes216 views2 answers
Django model form import
Python Django
2 votes172 views3 answers
No such table django
Python Django
10 votes209 views2 answers
Django import settings
Python Django
0 vote207 views1 answer
Django change foreign key
Python Django
1 vote219 views1 answer
How to get last values or data in django orm
Python Django
0 vote219 views1 answer
Get token from request django
Python Django
0 vote203 views1 answer
Django populate form from database
Python Django
5 votes200 views1 answer
Check django object exists
Python Django