/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 vote150 views1 answer
"PyGTK" python setup.py egg_info Check the logs for full command output.
Python
6 votes139 views2 answers
Iterable meaning
Python
0 vote181 views1 answer
Foreignkey as users from a user group django
Python Django
3 votes171 views4 answers
Password generator
Python
0 vote147 views1 answer
Equivalent of setInterval python
Python
1 vote142 views2 answers
Check all values in dictionary python
Python
219 votes358 views6 answers
Random number python
Python
0 vote144 views1 answer
Django collectstatic with auto yes
Python
0 vote168 views1 answer
Add readme cmd
Python
0 vote149 views3 answers
Convert c++ code to python online
Python