/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

8 votes306 views3 answers
How to install whl file in python
Python
0 vote247 views2 answers
Pydrive upload file to folder
Python
4 votes287 views2 answers
Loginrequiredmixin django
Python Django
3 votes269 views2 answers
Python save a dictionary as an object
Python
0 vote254 views1 answer
Unique_together what is used of it in django
Python
0 vote250 views1 answer
Functools.cached_property objects in python
Python
0 vote216 views6 answers
Convert from python code to c++ code
Python
0 vote245 views1 answer
Dont truncate dataframe jupyter pd display options
Python
0 vote247 views1 answer
Files and exceptions not working python
Python
1 vote258 views1 answer
Shapely polygon from string
Python