/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

0 vote227 views1 answer
Django pull from Google Sheets
Python Django
1 vote191 views2 answers
Django make new application folder
Python Django
0 vote186 views1 answer
?: (admin.W411) 'django.template.context_processors.request' must be enabled in DjangoTemplates (TEMPLATES) in order to use the admin navigation sidebar.
Python Django
0 vote191 views1 answer
Make value of two tables unique django
Python Django
1 vote193 views1 answer
Django queryset group by count
Python Django
-1 vote194 views2 answers
How to url encode using python django
Python Django
0 vote200 views1 answer
Redis in django channels
Python Django
8 votes192 views2 answers
What does class meta do in django
Python Django
0 vote222 views1 answer
Load local data to django
Python Django
0 vote182 views1 answer
Django.db.utils.ProgrammingError: can't adapt type 'dict_keys'
Python Django