/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

0 vote197 views1 answer
Index in the pool python
Python
0 vote202 views2 answers
Change pip to python 3.9
Python
0 vote206 views1 answer
Freqtrade - Informative Pairs
Python
4 votes208 views1 answer
Sort dict by value
Python
0 vote227 views1 answer
How do i get auth user model dynamically in django?
Python Django
0 vote208 views1 answer
How to use drf pagination directly
Python
0 vote195 views1 answer
Set lable of field django
Python
21 votes223 views6 answers
Make virtual environment python
Python
0 vote197 views1 answer
Run all python files in a directory in windows
Python
2 votes194 views2 answers
How to find a word in a string python
Python