Drill into Visualization

On dashboards, you can add drill interactions to your visualizations which link the original visualization to any other existing visualization. By clicking the data in the visualization, the target visualization then opens.

A visualization displaying multiple metrics, attributes, or both can have an independent drill interaction for each.

Create a Drill into Visualization

In this example, you will add a drill interaction to a metric. The same procedure can be used to add a drill interaction to an attribute.

Steps:

  1. Edit your dashboard and click on the visualization that you want to set up a drill path for.

    The options menu opens.

  2. Select Interactions.

    A visualization titled Percentage of Customers by Region is selected. The Interactions option is highlighted in the menu opened via the ellipsis button in the top-right corner of the visualization.
  3. Click + Add interaction and select the metric you would like to drill in on.

    The Interactions dialog with the Add interaction button clicked. This opens the When I click on dialog, where a metric labeled Number of active customers is selected under Value of metric.
  4. In the first dropdown menu, select Drill into visualization.

    In the second dropdown menu, select the target visualization you would like to drill in on.

    The I want to section of the Interactions dialog is expanded. Drill into visualization is selected from the first dropdown, and the title of the target visualization is selected in the second.
  5. Save & Publish your changes.

    Notice that if you hover over the visualization now, you are able to click on a metric to drill in on it.

    A user hovers over the West region in the July data point in the Percentage of Customers by Region visualization. The tooltip shows metric values and includes a Click chart to drill prompt.

    For example if you click on the 2021-07 data point for the West region as shown on the previous image, you open the Product Categories visualization and in it you see the breakdown by category of sold items in the West region within the July period.

    The Product Categories pie chart shows results filtered to West region and July 2021. Categories include Electronics, Outdoor, Clothing, and Home.

Filters in Visualization Drilling

The target visualization is filtered by the following filters:

  • Filters configured in the dashboard filter bar and active for the source visualization.

    The dashboard filters in the top toolbar. Date range is set to All time and Restaurant Category is set to Fine Dining. Red arrows point to a filtered visualization with the same values applied.
  • Filters configured in Analytical Designer for the target visualization.

  • Attribute value you click on in the source visualization. When you click on a value in Fine dining, the target visualization filters only to Fine dining.

    A bar chart titled Checks up to $15 shows values for Fine Dining. A tooltip highlights the Coffee category with an average check size of $3.9764.