/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

1 vote194 views1 answer
How to run the server in django
Python Django
1 vote150 views1 answer
Python app to deb
Python
40 votes191 views5 answers
New line print python
Python
5 votes149 views1 answer
Make jupyter notebook wider
Python
-1 vote148 views4 answers
How to loop over all dates in python
Python
0 vote142 views1 answer
Python parser txt to excel
Python
0 vote192 views1 answer
Mehrzeiliges kommentar python
Python
1 vote106 views1 answer
Python get keys as list
Python
0 vote140 views1 answer
To_bytes python
Python
0 vote144 views1 answer
Python matplotlib pyplot set axis equals
Python