/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 vote177 views1 answer
Exit a pygame program
Python
22 votes178 views4 answers
Python is float
Python
0 vote259 views1 answer
Staff user is not restricting permission in django
Python
30 votes172 views6 answers
Pandas drop columns
Python
0 vote187 views1 answer
Python unzip list of tuples
Python
0 vote214 views10 answers
Sqlite3 with flask web application CRUD pdf
Python Flask
1 vote214 views3 answers
How to use variable from another function in python
Python
1 vote214 views1 answer
Show all numpy array
Python
1 vote177 views1 answer
'Polygon' object has no property 'normed'
Python
0 vote181 views1 answer
You are trying to add a non-nullable field without a default
Python