Group rows by day

[bonomi]

Hi everyone. I’m fully aware that this must be extremely simple, but I’m new and can’t wrap my head around everything yet.

I’m querying messages posted by date. The result is many rows like this:

DATE, MESSAGES
date x, 1
date x, 2
date x ,2
date y, 2
date y, 2
date z, 3

I would really love to have it look like this:
DATE, MESSAGES
date x, 5
date y, 4
date z, 3

Easy, right? 🙂

[Dawid · Accepted solution]

You need to make sure you have a measure messages and not just a dimension. A measure will be aggregated. 

[bonomi]

Thanks, that makes sense now.