/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 vote342 views2 answers
While scraping table data i am getting output as none
Python
14 votes350 views3 answers
Shutdown/restart windows with python
Python
0 vote352 views1 answer
Data format pandas
Python
72 votes353 views6 answers
Python online
Python
1 vote364 views1 answer
Python replace all new lines with space
Python
0 vote383 views1 answer
Find different between list
Python
4 votes368 views1 answer
Django objects.create()
Python Django
1 vote344 views1 answer
How to get pygame key
Python
1 vote333 views1 answer
How to use pafy
Python
4 votes338 views3 answers
Matplotlib xticks font size
Python