Aggregate over date

[milosgajdos]

I’m pretty new to Looker. I’m trying to calculate aggregates per date in one of my views.

The table is pretty simple. It contains Date and a total number of X.

The result however yields something like this:
…
…
2020-10-06 | 12223
2020-10-06 | 233
2020-10-06 | 4555
2020-10-07 | 100
2020-10-07 | 323
…
…

This is just a small snippet, the result of the query is larger and is spanning multiple days.

What I’d like is to aggregate the counts per date i.e.
2020-10-06 | 23033
2020-10-07 | 4523
2020-10-08 | 2333
…

First, I tried to pivot the counts which yields views per/date but somehow, that produces this:

which is arguably much worse 🙂

Anyone know how to go about this?

Thanks