/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

8 votes242 views6 answers
Redirect django
Python Django
5 votes255 views1 answer
How to sort a list in python using lambda
Python
1 vote215 views1 answer
Different states of a button tkinter
Python
2 votes211 views1 answer
Python calculate time taken
Python
0 vote232 views1 answer
W0622: Redefining built-in 'zip' (redefined-builtin)
Python
5 votes232 views3 answers
How to add images in hml while using flask
Python Flask
5 votes228 views1 answer
Matplotlib change thickness of line
Python
24 votes222 views6 answers
Create a timestamp python
Python
2 votes229 views5 answers
Django documentation
Python
36 votes218 views4 answers
Drop multiple columns pandas
Python