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.

Note

The target visualization ignores any filters configured for the source visualization in Analytical Designer.

Drill to URL in Drill Into Visualization

You can make attribute values clickable links by using Drill to URL. You can define the default Drill to URL on the attribute level in your data model. When Drill to URL is enabled, links are applied automatically wherever the attribute is used in table visualizations, including tables opened in drill modals.

Drill to URL can be controlled at these levels:

  • Organization, workspace, or user (default behavior)
  • Visualization (configured in Analytical Designer)
  • Dashboard widget (configured in dashboard interaction settings)
  • YAML (Analytics as Code)

How It Works

  • If Drill to URL is enabled at the organization, workspace, or user level, GoodData automatically adds a Drill to URL action for attributes that have a hyperlink label in the data model.
  • If other interactions exist for the same attribute (for example, cross-filtering or Drill into visualization), Drill to URL appears as an additional item in the interaction menu (for example, More details).
  • If Drill to URL is the only available action, clicking the attribute value opens the URL directly.

Manual Drill to URL rules you add on a visualization or widget are not overwritten by the automatic setting. Automatic links are added only when no manual rule exists.

Configure Drill To URL

You can configure Drill to URL for a visualization in Analytical Designer:

  1. Open the visualization in Analytical Designer.
  2. Open Interactions.
  3. Toggle Drill to URL.

You can also override Drill to URL for a widget in dashboard Interactions. For example, you can remove URL drilling from a specific widget even if it is enabled globally.

If you use YAML (Analytics as Code), Drill to URL can be exported and imported. The YAML includes the Drill to URL setting only when you override the current default behavior for that visualization.

Deterministic Label Selection And Warnings

Only one hyperlink label is used for each attribute. If an attribute has multiple hyperlink labels, GoodData uses the first label in metadata order. In this case, the platform shows a model warning that multiple hyperlink labels are not supported for Drill to URL, and recommends keeping only one hyperlink label per attribute.

Limitations

  • Drill to URL is not executed in exports (PDF/XLS), alerts, or scheduled emails.
  • Only one hyperlink label per attribute is supported.
Drill into Dashboard