/Python/Django/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 vote329 views1 answer
Delete and start fresh with db django
Python Django
1 vote378 views1 answer
Django group by date from datetime field
Python Django
6 votes335 views2 answers
Django read mesage
Python Django
9 votes363 views1 answer
Create models in django
Python Django
31 votes474 views6 answers
Django admin create superuser
Python Django
0 vote351 views1 answer
Abstract user in django
Python Django
2 votes361 views1 answer
Truncate templat tag django
Python Django
1 vote337 views1 answer
For loop in django
Python Django
1 vote371 views1 answer
How do i check if a django queryset is empty
Python Django
1 vote325 views1 answer
Django get id of newly created object
Python Django