/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 vote344 views1 answer
Access django server from another machine
Python Django
0 vote330 views1 answer
Dynamic footer in django
Python Django
2 votes332 views1 answer
Django model current timestamp
Python Django
1 vote316 views2 answers
Django make new application folder
Python Django
1 vote328 views1 answer
Error popup in django not visible
Python Django
0 vote365 views2 answers
Create blog in django
Python Django
0 vote394 views1 answer
Credential not provided when i try to sign up a new user django
Python Django
0 vote317 views1 answer
Reverse relationship in django for one to one field for usage in Django rest serializer
Python Django
0 vote316 views1 answer
Django date grater
Python Django
1 vote294 views3 answers
Django logout user
Python Django