Drill Down in KPI Dashboards

Overview

On KPI Dashboards, you can use the existing attribute drill paths that are defined to drill to when you click on an attribute value.

You can configure the drill paths in the Manage section. For more information, see Defining Global Drill Down Paths.

Steps

If the insight you add to a KPI Dashboard includes an attribute with a drill path configured, drill down works automatically.

Just click a fact, metric, or attribute value in the insight and the dashboard opens a drill window where the fact, metric, or attribute is:

• Filtered to the value you selected (clicked) in the original report, and
• Broken across the attribute from the drill down path.

See the following section for examples.

Examples

Single drill down

1. Create an insight that includes the number of your Restaurants viewed by the Location state. 
   
   
2. In the Manage section, set the Location state attribute drill down path to Location city. 

   

3. Add the insight to a KPI Dashboard and save the dashboard.
4. To see in which cities are the restaurants in California, click the California column. 

   

The KPI Dashboard opens a drill window displaying number of restaurants in California viewed by city.

Multiple drill downs

1. Create an insight that includes the number of Checks in your restaurants viewed by Year. 

   

2. In the Manage section, set the following drill down paths: - Year to Quarter - Quarter to Month - Month to Week - Week to Day
3. Add the insight to a KPI Dashboard and save the dashboard.
4. To see the number of checks broken across quarters in 2011, click the 2011 column. The KPI Dashboard opens a drill window displaying number of checks in 2011 viewed by quarter. 
   
   
5. To see the number of checks broken across months in Q3 in 2011, click the Q3/2011 column. The drill window now displays the number of checks in Q3 in 2011 viewed by month. 
   
   

You can continue as long as you have drill down paths configured.

Multiple types of drilling

1. Create an insight that includes number of Opportunities viewed by Departments. 
   
   
2. Create an insight that show number of Won opportunities by Sales representative. 
   
   
3. In the Manage section, set the following: - Department attribute drill down to Sales representative, and - Drill to insight for the Opportunities metric to display the Won opportunities by Sales representative insight. For details, see Drill to Insights from KPI Dashboards.
4. Add the insight from step 1 to a KPI Dashboard and save the dashboard.
5. Click the Direct Sales column to select which drill to use. 

   

6. To see the number of Opportunities broken across Sales representatives in the Direct Sales department, click the option under Drill down. 
   
   
7. To see the number of Won opportunities broken across by the Sales representatives in the Direct Sales department, click the option under Drill into.