Question

Aggregate over date

  • 13 October 2020
  • 0 replies
  • 71 views

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


0 replies

Be the first to reply!

Reply