Table, Number, Line, and Bar charts (and soon all other types of charts) can be set-up to trigger filtering as an alternative to the filters in the dashboard filter bar as well as navigation to another dashboard.
This can power several different use-cases:
* a more intuitive way to trigger filters from within the dashboard
* a Drill-down to an expanded / more detailed view of a specific value
* a Master/Detail selection within a single dashboard, where a selection on one chart controls what the other reports display
We refer to all of these via a general term "Drill-down".
To configure the behavior, select the "Drill-Down" tab in the chart configuration UI:
Here you can add one or more drill-down configurations, each defining the drill-down behavior for a specific table column or chart component (axis, value, column header, row header, etc. depending on chart type).
Table chart drill-down configuration
Column - the table chart column on which the drill-down links will appear.
Target dashboard - the target dashboard to navigate to or the same dashboard for a Master/Detail behavior. Note: only dashboards that have filters are displayed as options.
Filters list - a set of filters on the target dashboard to set and a selection of a column from the table chart that would be passed as a value to that filter. If no filters are defined, then a click on the drill-down would simply navigate to the target dashboard. If one or more filters are defined, these would be set on the target dashboard when the drill-down is performed.
Expand aggregation - this option is available in case the Filter is set to timerange and both the current and target dashboards use the aggregation filter. When set, the aggregation on the target dashboard is expanded to the next detail level from the current aggregation (e.g. when looking at data aggregated by Year, clicking on value will set the target dashboard aggregation to Quarter).
Drill-down on embeds
The drill-down support on embeds requires few extra steps, see Drill-down on embedded dashboards for details.