/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 vote290 views2 answers
How to add percentage in pie chart in python
Python
44 votes308 views3 answers
Bytes to string python
Python
1 vote279 views1 answer
Add year to id django
Python
3 votes282 views1 answer
Tkinter widget span multiple colums
Python
0 vote287 views1 answer
Optimize images using pillow
Python
0 vote289 views1 answer
Voting classifier grid search
Python
3 votes364 views1 answer
Python delete saved image
Python
3 votes299 views4 answers
Django setup in windows
Python
10 votes285 views3 answers
Convert a pandas column to int
Python
0 vote288 views1 answer
Can I activate a function inside the definition of the same function
Python