/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 vote134 views1 answer
Flask decoding base 64 image
Python
1 vote129 views2 answers
How to print 0 to 10 in python
Python
-1 vote124 views1 answer
Python remove \t
Python
0 vote127 views1 answer
Comment transformer un chaine de caractere en liste python
Python
0 vote122 views1 answer
Find and flag duplicates pandas
Python
-1 vote152 views1 answer
Date and time using tkinter
Python
69 votes131 views6 answers
How to activate venv python
Python
0 vote150 views1 answer
Python logger printing multiple times
Python
0 vote170 views1 answer
Ffff in decimal python
Python
9 votes127 views2 answers
How to make a resizable python tkinter window have a limit
Python