I am using an Explore (with two joined views/tables) as my data source in Looker Studio.
The two views are: (1) a daily purchase table by store; (2) a store hierarchy table with area, region, etc. They are joined in LookML by store id, with only the store id from the hierarchy table available as a dimension in the Explore.
I want to be able to filter by region in Looker Studio to see number of purchases, but it is treating the two tables in the Explore as separate data sources, despite having been added as one. Does anyone have a suggestion of a workaround? I’ve tried blending the data source with itself but to no avail - perhaps there’s a way with custom filtering? I’d be grateful if anyone has had any success with this