Hello,
Could you please help me?
I would like to add two data sources to a Looker chart in such a way that my dimensions are not affected by the time filter, while only my measures respond to this filter.
Thanks
Maybe create a parameter and then create a measure that references the parameter? For example, if you had a simple sum measure like this:
SUM(dimension 1)
Then, you could make it listen to a parameter like this:
SUM(CASE WHEN dimension2=parameter1 THEN dimension1 ELSE 0 END)
User | Count |
---|---|
1 | |
1 | |
1 | |
1 | |
1 |