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