/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 vote200 views1 answer
Split string by delimiter string
Python
0 vote245 views1 answer
Python staticmethod property
Python
-3 votes260 views1 answer
ImportError: cannot import name 'SGD' from 'keras.optimizers' (/usr/local/lib/python3.7/dist-packages/keras/optimizers.py) site:stackoverflow.com
Python
0 vote216 views1 answer
Python print list items vertically
Python
0 vote227 views1 answer
Python: dunder init method
Python
0 vote238 views1 answer
How to usepygame.sprite.spritecollide
Python
1 vote247 views1 answer
Count decimal number python
Python
5 votes235 views2 answers
How to get first element of array in python
Python
1 vote236 views2 answers
Get current week python
Python
-1 vote237 views1 answer
Receipt data extraction python
Python