Drill to Insights from KPI Dashboards

Overview

On KPI Dashboards, you can enable drilling from facts, metrics, or attributes to any existing insight. By clicking on a fact, metric, or attribute in the View mode (not while editing), the target insight then opens.

Steps

1. Add an insight to a KPI Dashboard. For details, see Set up KPI Dashboards.

2. Click the insight. The options menu opens.

3. In the Interactions section, click Add interaction.

4. Select for which item to set the drilling. 

   
   

5. In the I want to drop-down menu, select Drill into insight. 

   

6. Select to which insight you want to drill when clicking on the fact/metric/attribute. 

   
   

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

8. Click Save & Publish.

Now to open the target insight in a pop-up window:

• Click a value in the source insight if you drill from facts/metrics (all insights) or attributes (all except pivot tables).
  
  
• Click an attribute value, if you drill from attributes in a pivot table. The image shows a table without drilling (left) and with drilling on the Menu category attribute (right). 
  
  

  If multiple drills are configured, you can select where to drill when you click a fact, metric, or attribute.

  

  If you remove a source fact/metric/attribute from the insight, KPI Dashboards remove the drilling from the insight and display a message when you edit the dashboard. 

  

  

Filters in drilling

The target insight is filtered by the following filters:

• Filters configured in the KPI Dashboard filter bar and active for the source insight. 
  
  
• Filters configured in Analytical Designer for the target insight.
• Attribute value you click on in the source insight. When you click on a value in Fine dining, the target insight filters only to Fine dining.