/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 vote167 views1 answer
Queryset.raw() in django rest framework joining tables
Python Django
1 vote165 views1 answer
How to filter queryset with foreign key in django
Python Django
0 vote159 views1 answer
Dynamic footer in django
Python Django
2 votes177 views2 answers
Django and operator
Python Django
1 vote177 views1 answer
Display data from database in django
Python Django
0 vote166 views2 answers
Django edit object foreign key id
Python Django
1 vote170 views1 answer
Django filter after annotate
Python Django
0 vote167 views1 answer
?: (admin.W411) 'django.template.context_processors.request' must be enabled in DjangoTemplates (TEMPLATES) in order to use the admin navigation sidebar.
Python Django
3 votes194 views1 answer
Django user group check
Python Django
0 vote162 views1 answer
What is *args and **kwargs in django
Python Django