/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

0 vote333 views1 answer
Django or
Python Django
23 votes498 views3 answers
Django rest framework
Python Django
1 vote346 views1 answer
Delete and start fresh with db django
Python Django
0 vote343 views2 answers
Django form formatting
Python Django
1 vote367 views1 answer
Django filter after annotate
Python Django
0 vote358 views1 answer
Django get all model fields
Python Django
3 votes408 views2 answers
Update_or_create django
Python Django
3 votes381 views1 answer
Django group by
Python Django
0 vote381 views1 answer
Import external script in django views
Python Django
0 vote381 views1 answer
Or operator in django queryset
Python Django