/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 vote179 views1 answer
Full dist upgrade kali
Python
0 vote208 views1 answer
Promote a row in panda dataframe to header
Python
0 vote197 views1 answer
Replace string using regex
Python
0 vote203 views1 answer
Np.zeros data type not understood
Python
43 votes257 views6 answers
Reverse string python
Python
0 vote190 views1 answer
List Get a Element
Python
1 vote255 views1 answer
How to remove plotly toolbar
Python
0 vote180 views1 answer
How to install arcade in python
Python
0 vote196 views1 answer
Remove items from list while iterating python
Python
1 vote180 views1 answer
Distribution plot with curve python
Python