Drill to URL from KPI Dashboards

Contents:

Overview

You can configure drilling for any insight you add to your dashboard. Drilling for KPIs is not supported.

On KPI Dashboards, you can enable drilling from measures to URL addresses. You can drill to an attribute hyperlink label or a custom URL with placeholders.

By clicking on a measure in the View mode (not while editing), the target URL then opens in a new window or the dashboard sends a post message with the target URL.

The option to send a post message is available only for embedded KPI Dashboards. For details, see Embed a KPI Dashboard.

Steps

  1. Add an insight to a KPI Dashboard.
    For details, see Set up a KPI Dashboard.
  2. Click the insight.
    The options menu opens.
  3. In the Interactions section, click Add interaction.
  4. Select for which measure to set the drilling.
  5. In the I want to drop-down menu, select Drill into URL.
  6. Click Choose URL.
  7. To drill to a URL defined in the attribute label, select the label in the Hyperlink in attribute label section.

    This option is available only if the insight contains attributes with the hyperlink label defined. For more details, see Attributes in Logical Data Models.

  8. To drill to a custom URL, click Custom URL.
    For details, see section Custom URL.

  9. (Optional) Repeat steps 3-6 to add more drilling.
    You can add drilling for each measure in the insight.

  10. Click Save & Publish.

Custom URL

You can define any URL in the Add custom URL dialog.

You can add attribute label values or identifiers, such as project ID, insight ID, widget IDdashboard ID, data product ID, or client ID, as parameters in the URL definition. These parameters are then replaced by appropriate values during drilling.

If you add a URL without any parameters, all measure values drill to this single URL.

If the URL is missing the protocol prefix, https:// is added automatically.

Here are some examples of the URLs you can define:

  • Add a dynamic URL with query parameters using attribute labels as parameters
    https://www.yourcompany.com/app/?product={attribute_title(label.product.id)}&category={attribute_title(label.category.id)

    To add multiple query parameters, use & (ampersand) to connect them.

  • Add a dynamic URL as combined attribute hyperlink label and project identifier
    {attribute_title(label.product.url)}?project={project_id}
  • Add a dynamic link using attribute label as a parameter
    https://www.yourcompany.com/products/{attribute_title(label.product.id.name)}
  • Add search on a specific site using an attribute label as a parameter
    https://www.mysearchengine.com/search?q=site:my.company.com-ATTRIBUTE_TITLE(label.product.name)
  • Add a direct link to a page
    https://www.gooddata.com/embedded-analytics


Powered by Atlassian Confluence and Scroll Viewport.