In addition to the regular controls in the UI of a dashboard, the UI of many types of report charts, such as Table, Number, Line, or Bar charts, can be configured to allow changing the values of query parameters used in the associated report. Furthermore, a chart UI can allow navigation to another dashboard. There are various use-cases:
- A more intuitive way to change parameters while inspecting a particular chart on the dashboard.
- Navigation to an expanded or more detailed view for specific data, e.g. provided by another dashboard.
- A form of Master/Detail selection within a single dashboard, where a selection on one report chart determines what is displayed in other reports.
Such functionality is referred to in the UI as a "Drill-down".
If a particular report chart supports drill-down functionality, a "Drill-Down" tab is shown in the chart configuration UI:
You can add multiple drill-downs to a single chart, each defining the drill-down behavior for a specific chart UI component, such as a table column, axis, value, column header, row header, etc., depending on chart type. The following screenshot shows the drill-down UI for a Table chart:
The configuration options are (from the top):
Column: The table chart column on which the drill-down links will appear.
Target dashboard: The target dashboard to navigate to, which can be the same dashboard. Note that only dashboards that have configurable filters can be used.
List of filters: The list of filters on the target dashboard whose values should be set. The associated column from the table chart determines the value of the 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.
This option is only available if a filter is a timerange filter and both the current and the target dashboard use parameterized time aggregation. When set, the aggregation on the target dashboard is expanded to the next level of granularity from the current aggregation, e.g. when the current chat shows data aggregated by Year, clicking on a value of such a drill-down will set the target dashboard aggregation to Quarter). This behavior thus implements the effect of "zooming in" to a more detailed view of the currently viewed data.
Drill-Down on Embedded Dashboards
For drill-down support on embedded dashboards, see here.