/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 vote246 views1 answer
Get a list of ids from queryset django
Python Django
0 vote250 views1 answer
Django serializer,
Python Django
0 vote243 views1 answer
Django change settings at runtime
Python Django
0 vote213 views1 answer
Django many to many post update method via rest
Python Django
0 vote226 views1 answer
Django create object with default today date
Python Django
0 vote190 views2 answers
Deploy django with nginx and gunicorn
Python Django
1 vote264 views1 answer
Django templateview
Python Django
8 votes319 views5 answers
Django message framework
Python Django
0 vote225 views1 answer
How to get parent model object based on child model filter in django
Python Django
0 vote226 views1 answer
Djangodebug toolbar not showing
Python Django