Hi all,
I’m building a sales dashboard where reps select an airline carrier from a top filter control (dropdown, bound to a dimension field, e.g. id_validating_carrier). This filter correctly drives most of the page: monthly performance, top routes table, share by provider, etc.
The problem is with one specific table: a “Market Share” table that should always show all carriers for a given route, regardless of the carrier selected in the top filter. It’s fed by clicking a row in a separate “Top Routes” table (this route-based cross-filtering already works correctly).
What I need: the Market Share table should ignore the top carrier filter control entirely, but still respect the route selection coming from the Top Routes table click interaction.
What I’ve tried so far:
- Converting the carrier filter control to use a Parameter instead of a dimension field, then adding a chart-level filter (
Carrier Match = 1) on every chart except Market Share. This technically works but requires manually listing every carrier value in the parameter’s “List of values,” which isn’t maintainable since the carrier list changes. - Duplicating the data source and pointing the Market Share chart to the duplicate, plus creating a renamed pass-through calculated field for the carrier dimension (new field ID) in the duplicate. The carrier filter still cascades to the chart even after this.
- Looking for a per-chart “Interactions” control to selectively exclude a filter control — I can’t find this option in my version of the editor.
Is there a supported way (via the filter control’s own scope settings, chart interactions, or another method) to exclude a single chart from a page-level filter control while keeping a different cross-filter interaction active on that same chart? Screenshots of exact menu locations would be hugely appreciated since I haven’t been able to find this in my UI.
Thanks in advance!