/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

5 votes275 views4 answers
If queryset is empty django
Python
4 votes273 views1 answer
Python spawn shell
Python
1 vote284 views1 answer
How to make table using python
Python
46 votes272 views6 answers
Python random list
Python
0 vote248 views1 answer
Check if numpy array contains only duplicates
Python
1 vote244 views1 answer
New working version of linkchecker
Python
-1 vote256 views2 answers
Sequence python
Python
0 vote264 views1 answer
If else usage python
Python
0 vote299 views1 answer
Import data in pandad
Python
4 votes271 views4 answers
Pandas rename specific column
Python