/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 vote169 views1 answer
Capitalize first word of a phrase in python
Python
0 vote177 views1 answer
What is primary key in python
Python
0 vote133 views1 answer
How to sort subset of rows in pandas df
Python
0 vote154 views1 answer
Django update field after save
Python
1 vote203 views1 answer
Django queryset multiple filters
Python Django
0 vote172 views1 answer
Software developer tools list
Python
0 vote173 views1 answer
Python list files only in given directory
Python
3 votes122 views1 answer
Images from opencv displayed in blue
Python
0 vote168 views1 answer
Python pipe where
Python
0 vote185 views1 answer
Show battery of my laptop python
Python