Hi, I have country as a dimension in my data and having various metric corresponding to it. I want to allow users in my dashboard to select country 1 and country 2 so that they can compare metrics for their selected countries side by side
I’ve done this with merged tables. Not ideal, but functional. Your dashboard is just setup with two country filters that apply separately to the source tables which are merged.
From a Lookml perspective, I believe you’ll want to use derived tables and filters that apply to them, respectively.
Part of any data model I work with is aggregation.. a big table with few dimensions but many metrics. We’ve had a similar problem not being able to look at multiple metrics across different values of a dimension. Aggregation solves the problem