Django count number of records per day

Question

I'm using Django 2.0

I am preparing data to show on a graph in template. I want to fetch number of records per day.

This is what I'm doing

qs = self.get_queryset().\
        extra({'date_created': "date(created)"}).\
        values('date_created').\
        annotate(item_count=Count('id'))

but, the output given is

[
    {'date_created': datetime.date(2018, 5, 24), 'item_count': 1},
    {'date_created': datetime.date(2018, 5, 24), 'item_count': 1}, 
    {'date_created': datetime.date(2018, 5, 24), 'item_count': 1}, 
    {'date_created': datetime.date(2018, 5, 24), 'item_count': 1}, 
    {'date_created': datetime.date(2018, 5, 24), 'item_count': 1}, 
    {'date_created': datetime.date(2018, 5, 24), 'item_count': 1}, 
    {'date_created': datetime.date(2018, 5, 24), 'item_count': 1}
]

Here data is not grouped and same date is returning repeatedly with count as 1

There is similar question to your question, You can use this [answer](https://stackoverflow.com/questions/10154227/django-orm-group-by-day?utm_medium=organic&utm_source=google_rich_qa&utm_campaign=google_rich_qa) — Minuddin Ahmed Rana, Jun 06 '18 at 07:08

score 0 · Answer 1 · answered Jun 06 '18 at 07:28

0

Try using TruncDate function.

See that answer

answered Jun 06 '18 at 07:28

afilardo

527
2
16

`TruncDate` returns `None` – Anuj TBE Jun 06 '18 at 08:33

Django count number of records per day

1 Answers1