/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

0 vote106 views1 answer
Flask mongoengine getting started
Python
0 vote111 views1 answer
Programação funcional python - append
Python
1 vote130 views1 answer
Multiple functions tkinter
Python
0 vote117 views1 answer
B12 vegetables only
Python
6 votes117 views1 answer
Excute a command using py in cmd
Python
1 vote121 views1 answer
Mnist fashion dataset
Python
0 vote117 views1 answer
Pandas installation in python2
Python
0 vote103 views1 answer
Sns add spine
Python
4 votes115 views3 answers
List methods append in python
Python
1 vote109 views1 answer
Rotation points space python
Python