/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

6 votes211 views3 answers
Messages django
Python
0 vote205 views1 answer
How to see what variable is closest to a higher element in python
Python
0 vote204 views1 answer
Install models python
Python
0 vote223 views1 answer
Tensorflow io check file exist
Python
0 vote245 views2 answers
Python - Comment jouer le fichier Mp3
Python
0 vote207 views1 answer
Binary to octal in python
Python
0 vote215 views1 answer
Install python 3.8 on wsl
Python
8 votes211 views4 answers
How to reverse a dictionary in python
Python
38 votes223 views6 answers
Datetime python
Python
5 votes224 views2 answers
Forgot django admin password
Python Django