/Python/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

1 vote288 views2 answers
Remove 1st column pandas
Python
0 vote303 views1 answer
How to make antivirus software in python
Python
-1 vote319 views1 answer
Flask run on ip and port
Python
2 votes283 views3 answers
Why is Python called Python
Python
0 vote308 views3 answers
Mechanize python fill
Python
-1 vote286 views3 answers
Sum of multiples of 3 or 5 python
Python
6 votes306 views3 answers
Infinty in python
Python
0 vote310 views1 answer
Python use numphy
Python
0 vote308 views1 answer
Couldn't open showimage no such file or directory
Python
1 vote334 views1 answer
Special characters list in python
Python