/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 vote271 views1 answer
Get nonzero min numpy
Python
0 vote238 views1 answer
How to skip the first line of a csv file
Python
10 votes242 views4 answers
How to print all items in a list python
Python
0 vote242 views1 answer
How to sort a list in python with if
Python
1 vote245 views2 answers
Python timedelta to seconds
Python
0 vote229 views2 answers
Input numpy array
Python
0 vote241 views1 answer
BusyIndicator Import
Python
0 vote242 views1 answer
Create a hexadecimal colour based on a string with python
Python
0 vote245 views1 answer
Windows error message python
Python
2 votes200 views1 answer
Check if user has manage messages discord.py
Python