/Python/Django/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

2 votes133 views2 answers
How to check django rest framework version
Python Django
0 vote140 views1 answer
Http404 django
Python Django
0 vote149 views1 answer
How to run django in jupyter
Python Django
1 vote130 views1 answer
For loop in django
Python Django
0 vote135 views1 answer
Redirect a post request django
Python Django
6 votes92 views5 answers
Manage.py", line 12, in main raise importerror( importerror: couldn't import django. are you sure it's installed and available on your pythonpath environment variable? did you forget to activate a virtual environment
Python Django
0 vote135 views2 answers
Stable version of django
Python Django
0 vote137 views1 answer
Staff user is not restricting permission in django
Python Django
1 vote130 views1 answer
How to add an active class to current element in navbar in django
Python Django
0 vote129 views1 answer
How to instal django cities
Python Django