Summarizing over Start and End Dates

(Eric) #1

I’m trying to accomplish what is perfectly described here:

In fact, I’m using the “antipattern”, and I’d like to transition to the performant style. However, I can’t figure out how to make it work in LookML – that is, allow the user to select the time period (day, month, or week), allow the user to join to other dimensions, etc. Any ideas?


(fabio) #2

This other article I wrote doesn’t exactly write it for you, but should give you a pretty good starting point (see in particular the “Sharing is Caring” section)

(Eric) #3

Thanks, Fabio! Those two articles are really helpful.