Configure drilldowns
Configure drilldowns from dashboard widgets to detailed data.
Enable users to dive deeper into data by configuring dashboard drilldown actions on individual widgets that trigger actions when a dashboard user clicks on a data point in the widget. Clicking a configured widget can trigger contextual changes, or seamlessly link users to:
An XQL search
A custom URL
Another dashboard
A report
A filtered page
Once configured, these drilldowns are instantly available to any authorized user.
Open the dashboard builder.
Select a dashboard from the Dashboard Manager and click Edit.
Select a widget.
Identify the widget on which you want to configure an action, click its options menu (the three vertical dots in the widget frame), and select Configure action on click.
Configure your drilldown action.
Choose one of the following configuration options under Action on Click:
Filter this dashboard: Interactively filters the active dashboard using parameters defined in your custom XQL widgets. (Requires parameters to be configured within the XQL widget query).
Parameters
Select the parameter to filter by. You can choose any parameter defined in the widget's XQL query.
Value from
Define the data point that will trigger the filter when a user clicks the widget. You can:
Type a static value.
Select a variable to capture the clicked value dynamically. The listed values are extracted from the widget (e.g., $y-axis.value in a chart or a $row.value in a table).
Link to Dashboard: Navigates the user to a separate target dashboard.
Dashboard
Select your target dashboard from the list.
Parameters (Optional)
Select parameters to filter the target dashboard. (Available only if the target dashboard's widgets contain defined parameters.)
Value (Optional)
If configuring parameters, select values for filtering the target dashboard. You can:
Type a static value.
Select a variable to capture the clicked value dynamically. The listed values are extracted from the widget (e.g., $y-axis.value in a chart or a $row.value in a table).
Open XQL Search: Runs a specific XQL query based on the clicked value.
XQL Query
Enter the query you want to execute upon drilldown.
Type $ to open the autocomplete menu for available widget variables (e.g., in a table widget, $first.name selects the leftmost column).
Open Custom URL: Opens an external web page based on the clicked value.
URL Address
Enter the destination URL. To make the link dynamic, insert variables from the Available parameters list.
Generate Report: Instantly runs a report using data from the clicked value.
Open Filtered View: Opens a target page filtered by a selected fields and values. (Available for specific view only)
FieldAction/DescriptionTarget view
Select the view you want to open on click
Field
Select a field on the target view by which to filter.
Value
Select a variable to capture the clicked value dynamically. The listed values are extracted from the widget (e.g.,
$y-axis.valuein a chart or a$row.valuein a table).
(Optional) Define opening behavior
Select Open in a new tab, to open the target in a new tab while retaining the existing dashboard.
Define the widget timeframe
Leave this option blank if you want to use the dashboard timeframe, or select Apply the widget timeframe and define the timeframe in the widget menu.
Save the widget.
Click Save on the widget dialog, and ensure you save your overall changes to the dashboard before exiting the editor.
Variables in drilldowns
The following tabs are organized according to widget type and describes the widget variables that are available to use in drilldown actions. The variable defines the value to capture in the drilldown, according to the element that is clicked. The captured value is then configured as a parameter by which to filter data on drilldown.
(Area, Bubble, Column, Funnel, Line, Map, Pie, Scatter, or Word Cloud)

$x_axis.name: Selects the x-axis name.$x_axis.value: Selects the x-axis value for the clicked value.$y_axis.name: Selects the y-axis name.$y_axis.value: Selects the y-axis value for the clicked value.

$y_axis.name: Selects the y-axis name that the single value represents.$y_axis.value: Selects the y-axis value for the clicked value.

$first.name: Selects the leftmost column name in the table.$first.value: Selects the leftmost value in the clicked table row.$clicked.name: Selects the column name of the clicked value.$clicked.value: Selects the value in the clicked table cell.$row.<field_name>: Selects the field (column) from the clicked table row.
c
Last updated
Was this helpful?
