Announcements
The Google Cloud Community will be in read-only from July 16 - July 22 as we migrate to a new platform; refer to this community post for more details.

how to add several data sources in a table chart looker without going through the combination?

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

0 1 162
1 REPLY 1

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)