/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

12 votes112 views6 answers
Progress bar in python
Python
2 votes129 views3 answers
How to set default python version linux
Python
3 votes108 views1 answer
Puissance python
Python
21 votes114 views5 answers
How to get input from list in python
Python
0 vote133 views1 answer
Delete all historical data django simple history
Python
0 vote104 views1 answer
Pass 2d array to 1d python
Python
8 votes113 views3 answers
Get_dummies
Python
8 votes110 views1 answer
X = df.iloc[:, 1:]
Python
3 votes124 views1 answer
Csrf token exempt django
Python Django
0 vote121 views1 answer
Printing float number python
Python