/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

15 votes151 views3 answers
Get the current year in python
Python
1 vote135 views1 answer
Matplotlib remove x and y labels
Python
4 votes154 views1 answer
Remove specific word from string using python
Python
0 vote185 views1 answer
Assign more than one variable at a time on a single line in python
Python
84 votes172 views6 answers
Sort dataframe by column
Python
0 vote174 views2 answers
Negation of boolean in pyhton
Python
0 vote136 views0 answer
Python
0 vote172 views1 answer
Python star sign before list
Python
2 votes156 views2 answers
Check if boolean is true python
Python
12 votes170 views2 answers
Isinstance float or int
Python