Table 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.
Value column - the column from which a filter value will be taken. Usually the same as Column, but in some cases you may want to display a label, but use an "id" value from another column (Hint: this column can be hidden in the table chart).
Target dashboard - the target dashboard to navigate to or the same dashboard for a Master/Detail behavior. Note: only dashboards which have filters are displayed as options.
Filter - the filter to set on the target dashboard (with the value taken from the Value column).
Expand aggregation - 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 a value will set the target dashboard aggregation to Quarter). Note: only visible in case the Filter is set to timerange and both the current and target dashboards use the aggregation filter.