/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 vote197 views1 answer
How to printing the words in a string? python
Python
0 vote174 views1 answer
Creating empty set and append python
Python
0 vote168 views1 answer
How to Create new dataframe columns from existing column
Python
2 votes138 views1 answer
Python text to ascii art
Python
0 vote188 views1 answer
Check permissions django template
Python
0 vote171 views1 answer
Python ip address is subnet of
Python
0 vote190 views1 answer
Tensorflow Bert implementation
Python
18 votes170 views3 answers
Get rid of n in string python
Python
0 vote201 views1 answer
Server error 500 heroku django
Python Django
0 vote195 views2 answers
Python dict for k v
Python