/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 vote221 views1 answer
Destructuring in for loops python
Python
2 votes211 views3 answers
Dockerfile to run python script
Python
0 vote214 views1 answer
How to return Fibbonaci(n) python
Python
16 votes206 views3 answers
Place a number randomly in a list python
Python
0 vote227 views1 answer
Pandas drop row from a list of vlaue
Python
0 vote231 views1 answer
Make tkinter text editing disabled
Python
0 vote220 views1 answer
Pandas Timedelta to postgres
Python
1 vote190 views1 answer
Logging python utf-8
Python
0 vote200 views1 answer
K and M to int in pandas
Python
0 vote193 views1 answer
Pygame get surface region
Python