/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 vote106 views1 answer
Tuple and dictionary in python
Python
0 vote126 views1 answer
Back button django template
Python
1 vote128 views1 answer
How to get the text from a label in tkinter
Python
-1 vote129 views3 answers
Isodate in python
Python
2 votes88 views3 answers
Encapsulate python
Python
0 vote255 views3 answers
Removing duplicates from django models data
Python
0 vote118 views1 answer
Pyqt5 how to see if clipboard is empty
Python
9 votes124 views1 answer
Python convery list to array
Python
-1 vote172 views2 answers
If __name__=='__main__':
Python
0 vote77 views1 answer
Cv2.filter2D(image, -2, kernel_3x3)
Python