/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 vote132 views1 answer
Import "whitenoise.django" could not be resolved
Python Django
0 vote73 views1 answer
Django creat app return _bootstrap._gcd_import
Python Django
2 votes129 views3 answers
Django login required decorator
Python Django
0 vote129 views1 answer
What is *args and **kwargs in django
Python Django
1 vote171 views1 answer
Permanent redirect django
Python Django
0 vote126 views1 answer
Django file upload this field is required
Python Django
0 vote129 views1 answer
Django how to create superuser if does not exists on migration
Python Django
3 votes161 views1 answer
Django session expire time
Python Django
0 vote123 views1 answer
Serializing nested objects drf,django restframework nested object serialization
Python Django
0 vote89 views1 answer
Django rest framework multiple user registration
Python Django