google-sheetsgraphfrequencytrellotypeform

How to get the count of inputs (complaints) received per day on google sheets?

Repeating dates

I receive n number of complaints via Typeform and have linked the typeform with google sheets.

For now, I have the data of all those complaints received from February 16 to March 16. The number of complaints i received per day vary, like 5 complaints of Feb 16th, 2 on 17th , 7-8 on 18th, you get the gist.

I would like to make a report using Bar graph which displays a simple formation of number of complaints received per day (ex. 5,10,15) on the vertical axis by dates (eg. Feb 14, Feb 15, Feb 16) in the horizontal axis.

That is all!

EDIT: I now have the dates being repeated in the graph , Can someone help me with the dates not being repeated ? thanks

Solution

  • Use the QUERY() function to get a distinct list of dates and the COUNT aggregation function to find the count of complaints.

    More info in the official Docs and (in my opinion better) more info from Ben Collins here