/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

-4 votes240 views4 answers
Latest version of django
Python Django
2 votes241 views1 answer
Django mysql
Python Django
1 vote283 views1 answer
Django template tags capitalize
Python Django
0 vote269 views1 answer
Django router multiple pk
Python Django
0 vote261 views1 answer
Function of this cod in django in django performance = serializers.SerializerMethodField() # def get_performance(self, instance): # return PerformanceSerializer(instance.performance).data
Python Django
0 vote276 views1 answer
Django filter values with e and operator
Python Django
0 vote255 views2 answers
Django swagger
Python Django
0 vote274 views1 answer
Django queryset to instance
Python Django
-2 votes253 views1 answer
Django e docker
Python Django
6 votes245 views2 answers
How to check if django is installed( in python shell)
Python Django