/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 votes373 views2 answers
Purpose of meta class in django
Python Django
0 vote296 views10 answers
PEP 428: The pathlib module – object-oriented filesystem paths.
Python
4 votes339 views3 answers
Docker run python
Python
4 votes327 views1 answer
Pandas transpose
Python
0 vote338 views1 answer
Blank lines with csv.writer
Python
0 vote341 views2 answers
Unable to import wx
Python
-1 vote334 views2 answers
How to set pandas dataframe as global
Python
0 vote353 views1 answer
Turn false true column into 0 1 pandas
Python
2 votes378 views3 answers
Matplotlib show plot
Python
78 votes342 views6 answers
Main python
Python