/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 vote331 views1 answer
Bootstrap 5 in Django
Python
0 vote278 views1 answer
Python find cursor position
Python
0 vote328 views1 answer
How to set gpu python
Python
-1 vote276 views1 answer
How to create user input in python
Python
0 vote332 views1 answer
Which type of programming does python support?
Python
0 vote351 views1 answer
Turn list of arrays into array
Python
1 vote338 views1 answer
How to Convert Strings to Datetime in Pandas DataFrame
Python
2 votes393 views3 answers
Play mp3 file python
Python
14 votes294 views4 answers
Find average in python
Python
0 vote368 views1 answer
AttributeError: module 'pyarrow' has no attribute 'parquet'
Python