Breaking News: Grepper is joining You.com. Read the official announcement!

group by month and year

Crowded Chipmunk answered on March 25, 2022 Popularity 8/10 Helpfulness 1/10

answer group by month and year

related Group by date (day, month, year)

group by month and year

Comment

Request.objects.extra({ "month": ExtractMonth('date_creation'),
                        "year": ExtractYear('date_creation') })
               .values('month', 'year')
               .annotate(total=Count('month'))
               .values('month', 'year', 'total')

Popularity 8/10 Helpfulness 1/10 Language python

Source: stackoverflow.com

Tags: group-by python

Link to this answer
Share Copy Link

Contributed on Mar 26 2022

Crowded Chipmunk

0 Answers Avg Quality 2/10

Closely Related Answers

Group by date (day, month, year)

Comment

from django.db.models.functions import TruncMonth
from django.db.models import Count

Sales.objects
    .annotate(month=TruncMonth('created'))  # Truncate to month and add to select list
    .values('month')                          # Group By month
    .annotate(c=Count('id'))                  # Select the count of the grouping
    .values('month', 'c')                     # (might be redundant, haven't tested) select month and count

Popularity 8/10 Helpfulness 1/10 Language python

Source: stackoverflow.com

Tags: date python group-by pytho

Link to this answer
Share Copy Link

Contributed on Mar 25 2022

Crowded Chipmunk

0 Answers Avg Quality 2/10

group by month and year

Contents

More Related Answers

group by month and year

Closely Related Answers

Group by date (day, month, year)

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.