/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

76 votes316 views6 answers
Python main
Python
7 votes319 views2 answers
Python remove html tags
Python
3 votes352 views2 answers
List of dict values
Python
4 votes318 views4 answers
Pandas rename specific column
Python
41 votes305 views6 answers
Python print new line
Python
0 vote394 views1 answer
Tkinter e.delete(0,END)
Python
3 votes366 views1 answer
No module named 'django.core.urlresolvers'
Python
2 votes324 views1 answer
Add whitespaces between char python
Python
0 vote391 views1 answer
Striding in python
Python
0 vote316 views1 answer
Selenium python has no attrirute getText
Python