Add a drilldown event to a data visualization on a technical dashboard

Technical dashboards do not support preconfigured destinations for drilling down from a data visualization. If you want a viewer to open a more detailed view of the data when they interact with a visualization, configure a custom drilldown event.

Before you begin

This procedure assumes that you have already created a technical dashboard and populated it with a data visualization component.

Warning: This procedure does not apply to Saved Visualization components.

Role required: ui_builder_admin, rights to edit a technical dashboard

Procedure

1. Navigate to All > Platform Analytics > Library > Dashboards.

2. Locate and open the desired technical dashboard.

3. Select Edit in UI Builder.

4. In the UI Builder, select the desired data visualization in the dashboard.

5. In the configuration panel for the data visualization, open the Events tab.

6. If your only option is to add an event mapping, do so.

1.  Select **Add event mapping**.

2.  In the list of events, select **Visualization Clicked**.

3.  Select **Continue**.

1. If the Visualization Clicked event is already listed on the Events tab, select Add handler for it.

1. Search for and select the Advanced dashboards - Redirect event handler and Continue.

1. Configure the event handler as follows.

   Field	JSON types	Description
   Context	object, with a string property named path	The path of the experience where the destination page resides.
   Route	none	The route name of the destination page.
   Route fields	object, with all parameters as strings	Required parameters for the destination page.
   Optional parameters		Optional parameters for the destination page.

   The required and optional parameters for common targets follows:

   Target	Route fields (required parameters)	Optional parameters
   List	{table:@payload.params.table}	{query:@payload.params.query}
   Record	{table: @payload.params.table, sysId: @payload.parms.row.sys_id.value}	None
   KPI Details	{uuid:@payload.params.indicatorSysid}	None

2. Select Add.

Drilldown for a table data source

You have a vertical data visualization that shows the number of records on the Incident [incident] table grouped by Priority. When a viewer interacts with this visualization, you want it to open a list of Incident records in the Platform Analytics experience.

Note: This example uses the Context of the Platform Analytics experience and default Route names to components therein.

1. You follow Steps 1-8 in the general procedure, so you now have the configuration open for the Advanced dashboards - Redirect event handler for your vertical bar visualization.
2. In the Context field, you select Edit.

1. In the editing dialog, you select the object JSON type.

1. You select Add property and enter path as the property name and now/platform-analytics-workspace as the property value. These values specify that the viewer drills down to the Platform Analytics experience.

1. You select Apply and move on to the next field.
2. In the Route field, you enter simplelist. This route leads to the simplelist page in the Platform Analytics experience.
3. For the Route fields, you first choose to bind data.

1. Then you add the property {table: @payload.params.table} to the field. This property passes the name of the table in your visualization to the simplelist page of the Platform Analytics experience.
   1. You select the Event payload property params and then table.

2.  You double-click, drag and drop, or select the arrow to add the property to the upper area of the editor.
3.  Double-click on the property in the upper area of the editor to open it for editing.

4.  You surround the `@payload.params.table` property with curly brackets and add the `table:` property.

5.  You select **Apply**.

1. Similarly, you choose to bind data for the Optional parameters field and set the value {query:@payload.params.concatenatedQuery}.

The properties of your Advanced dashboards - Redirect event handler now appear as follows:

In runtime, a user can interact with the visualization to open a list of Incident records.

Drilldown for an indicator data source

You have a Line data visualization for the indicator Number of open incidents. When a viewer interacts with this visualization, you want it to open the KPI Details page for that indicator.

1. You repeat steps 1-5 from the Table data source example, because in this case too you are drilling down to a page on the Platform Analytics experience.
2. For the Route, you enter ac_kpi_details.
3. For the Route fields, you first choose to bind data

**Tip:** First use autocomplete to add the data parameter `@payload.params.indicatorSysid`, then surround that parameter with curly brackets and add `uuid:`.

The properties of your Advanced dashboards - Redirect event handler now appear as follows:

|Field|Value|
|-----|-----|
|Context|\{"path":"now/platform-analytics-workspace"\}|
|Route|ac\_kpi\_details|
|Route fields|\{uuid:@payload.params.indicatorSysid\}|

1. No other parameters are necessary, so you select Add and then Save the UI Builder page.

In runtime, a viewer can interact with the visualization to open KPI Details for the Number of open incidents indicator.

Parent Topic:Technical dashboards

Related topics

More examples and information are available in KB2663434