/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 vote286 views1 answer
Filter startswith django
Python
1 vote306 views2 answers
Group by dateime pandas
Python
0 vote283 views1 answer
Django model manager user
Python
21 votes288 views6 answers
Set to List
Python
0 vote305 views1 answer
Starting variable name with underscore python
Python
14 votes301 views5 answers
Python trim whitespace from end of string
Python
0 vote267 views2 answers
Get script text selenium python
Python
0 vote304 views1 answer
How to use methods defined within class
Python
0 vote301 views1 answer
Split string by special characters python
Python
0 vote275 views1 answer
Loop through list, find specific number and output element's index
Python