/Python/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

1 vote255 views1 answer
Select realted for foreign key table in django
Python
82 votes275 views6 answers
Python version command
Python
28 votes267 views2 answers
Wintp python manage.py createsuperuser
Python
2 votes256 views10 answers
Javascript
Python
0 vote277 views1 answer
Make row readonly tablewidget pyqt
Python
2 votes337 views1 answer
Check if user log in flask
Python Flask
0 vote260 views1 answer
How to get the words inside a entry tkinter python
Python
1 vote245 views1 answer
Replace url with text python
Python
0 vote265 views1 answer
Change the frequency to column in pandas
Python
0 vote282 views1 answer
Python join list ignore none and empty string
Python