Adding a drill-through
In the dashboard builder, open the chart’s ⋮ menu and choose Add drill-through. A chart inside a stack, a grid or a tab gets the same item. The dialog lists every dashboard in the deployment that you can see, except the one you are editing, from A to Z by name. A chart never drills through to its own dashboard: cross-filtering already filters that dashboard by a clicked point, and adding such a drill-through through the Workbook Agent or the API is refused with that reason. A dashboard with a slug is shown as its slug in brackets followed by its name, such as[order-details] · Order details, and a dashboard without one by its name alone. Type in the search field to narrow the list by name or slug. Above the list, a note says what a target needs for this chart: “A target dashboard needs a slug and filters enabled for” followed by the titles of the chart’s dimensions.
Picking a dashboard shows, below the list, what it needs for this chart: its Slug, which the drill-through stores, and an Enable a filter for box for each of the chart’s dimensions that the target can’t take yet through a placed filter or its Dynamic controls widget. What you can do there depends on your access to the target:
- You can edit the target, and it doesn’t require review. The slug is editable. A target without a slug gets one made from the first three words of its title, with
-2,-3and so on added while another dashboard holds it. Every box starts checked. Save stays disabled while the slug is empty or a box is unchecked. - You can only view the target, or it requires review. The slug and the boxes are read-only and show the target as it is: an empty slug when it has none, and the boxes unchecked. A warning names the target’s owner, with their email, and asks you to have them set what is missing, such as “Ask Dana (dana@example.com) to set a slug and enable filters for Status in this dashboard’s settings.” Save stays disabled until the target has a slug and takes every dimension; then it stores the drill-through and changes nothing on the target.
- A changed slug is saved, after the same checks as the Slug field in the target’s dashboard options: see Changing the target’s slug. Cancelling there writes nothing to the target.
- The checked dimensions are added to the filters the Dynamic controls widget in the target’s draft allows. A draft without the widget gets one at its top.
- The same change is published at once, as a new version of the target built from the version its viewers see now, so the target’s other unpublished changes stay unpublished. The dialog says “Save publishes these filters on this dashboard. Its unpublished changes stay unpublished.”
Opening the target
On the published dashboard, a chart with a drill-through shows the drill-through icon when you hover the chart, with the tooltip “Drill-through enabled”. It sits to the left of the chart’s buttons that appear with it, since it only marks the chart: clicking it does nothing. On a touch screen, tap the chart to show them. Over the bars, points, lines, areas and slices of such a chart the pointer is a hand, as on a chart with cross-filtering on, even where the dashboard has cross-filtering off. Clicking a data point of a chart with a drill-through opens a menu whose first item is Open in followed by the target dashboard’s title, in a section of its own above Drill down, Comment on this point and the cross-filter items. The chart opens this menu even on a dashboard with cross-filtering off. Choose the item to open the target in the same tab; Cmd+click (macOS) or Ctrl+click (Windows and Linux) on it opens the target in a new tab. The browser’s Back button returns to the dashboard you came from, with its controls and cross-filters as you left them. The target opens with one filter parameter for each dimension of the point you clicked:- a bar, a line or area point, or a pie slice carries its category, plus its color or series value on a stacked, grouped or multi-series chart, and a scatter point carries every dimension it has;
- a table cell of a dimension column carries that value, and a cell of a measure column carries every dimension value in its row. In a pivot table, a value cell carries its row’s and its column’s values. A group row offers no Open in item;
- a map marker carries its row’s dimension values, and a map region carries the region. A cluster of markers offers no Open in item.
is filter, except a date shown at a granularity, which is a between filter over the period you clicked: the March 2024 bar of a monthly chart opens the target filtered from 2024-03-01T00:00:00.000 to 2024-03-31T23:59:59.999. In a table, Open in comes after the links that the column’s data model defines.
Drill-through works on published dashboards in Cube and on embedded dashboards, with private and signed embedding alike. An embedded dashboard opens the embedded target, inside the embed. In a signed embed, the item always opens the target in the same tab, Cmd/Ctrl+click included. In the dashboard builder, the version history and a review’s preview, a click on a chart does what it does on a chart with no drill-through.
The item is shown disabled, with a tooltip saying why, when it can’t open the target:
The title is read from the slug when the dashboard opens, so once another dashboard takes over the slug, the item names and opens that dashboard.
How the target applies the values
The target dashboard applies each value it arrives with, in this order:- To a placed filter on the same field.
- To a placed filter on the same cube dimension in another semantic view, when that view includes the dimension once. The filter parameter in the URL is rewritten to that field.
- To a filter added to the target’s Dynamic controls widget, when the widget allows filters on that field or, failing that, on the same cube dimension in another semantic view. The added filter shows the value, and the URL carries it as a
dc_parameter.
dashboard: link on a dimension or a link you write by hand. The target decides once, when it opens. Downloads, the print version, dashboard deliveries and alerts render the URL as it is, without these steps: a value that no control on the dashboard takes is left out, without a message. A download of a target you opened through a drill-through keeps the filters the drill-through added.