/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 vote224 views1 answer
Django MESSAGE_TAGS
Python Django
2 votes191 views1 answer
Hash table in python
Python
0 vote260 views1 answer
Add one to a column pands
Python
0 vote193 views1 answer
Customizable TKinter Buttons Python
Python
0 vote227 views1 answer
Isupper() in python
Python
24 votes192 views6 answers
Pd.read_excel
Python
5 votes225 views2 answers
Remove all of same value python list
Python
1 vote176 views1 answer
Stringf replcae in python
Python
0 vote264 views1 answer
Django dumpdata specific app
Python Django
2 votes184 views1 answer
Difference between sort and sorted
Python