Comparison : Country in dashboard

[Neeraj_Goswami]

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 

[Chris_Tinnon]

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. 

[Dawid]

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