/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 vote371 views1 answer
Python datetime floor to hour
Python
7 votes353 views3 answers
Subtract list from list python
Python
2 votes371 views3 answers
String contains element of list python
Python
3 votes385 views3 answers
Import flask
Python
98 votes346 views6 answers
Python random choice from list
Python
29 votes312 views2 answers
Lambda en python
Python
4 votes325 views1 answer
Dropdown in tkinter
Python
0 vote352 views1 answer
Any(iterable)
Python
0 vote288 views1 answer
Python draw state diagrams
Python
0 vote332 views2 answers
Enumerate word python
Python