# Explorer

KPI explorer can be used to filter rows, columns and measures, sort by name or value and highlight row/column hierarchies using rules or ranges.

{% embed url="<https://lumel.wistia.com/medias/spp06nf8xb>" %}
KPI explorer - Overview
{% endembed %}

### 1. Overview

Before taking a detailed look, let's quickly look at some important features in KPI explorer.

[Interface](#2.-interface) - The KPI explorer toolbar contains filters for measures, row and column categories and a date slicer (if dates are added to the visual).&#x20;

<figure><img src="https://content.gitbook.com/content/sB9HAei8v4FfKkH9M4gw/blobs/be4fCtTG0yoAAhC9OpBN/3.1.2.30%20Explorer.png" alt=""><figcaption><p>Explorer menu</p></figcaption></figure>

[Filtering](#3.-filtering) - As you make selections in the filter, both the table and the menu gets updated.&#x20;

<figure><img src="https://content.gitbook.com/content/sB9HAei8v4FfKkH9M4gw/blobs/jS3fTXdwOgexJfjLqO5C/3.1.2.33%20Explorer.png" alt=""><figcaption><p>Filtering using explorer</p></figcaption></figure>

[Customizations](#4.-customizations) - You can sort row/column hierarchies by name or value and highlight them using rules or ranges.&#x20;

<figure><img src="https://content.gitbook.com/content/sB9HAei8v4FfKkH9M4gw/blobs/M1qaXxhPtADpoqwr9MEj/3.1.2.34(2)%20Explorer.png" alt=""><figcaption><p>Customizations</p></figcaption></figure>

Let's take a detailed look.

### 2. Interface

In this report, we have Region and Category hierarchies in rows, Dates in columns and Actuals and Plan as measures. Outline layout is used in this example, but all table and measure layouts are supported when using KPI Explorer.

a) Click on the 'Explorer' icon in the 'Analyze' section of the 'Home' tab. &#x20;

<figure><img src="https://content.gitbook.com/content/sB9HAei8v4FfKkH9M4gw/blobs/zNaYG8Hv1GlmX7aQYDUm/3.1.2.2%20Explorer.png" alt=""><figcaption><p>KPI Explorer</p></figcaption></figure>

b) KPI Explorer menu gets enabled as shown.&#x20;

<figure><img src="https://content.gitbook.com/content/sB9HAei8v4FfKkH9M4gw/blobs/MRw1AbxBdLKkmd9N22hk/3.1.2.26%20Explorer.png" alt=""><figcaption><p>KPI Explorer menu</p></figcaption></figure>

c) Let's go to the full view. Click on the arrow highlighted and select the 'Explorer full view' option.

<figure><img src="https://content.gitbook.com/content/sB9HAei8v4FfKkH9M4gw/blobs/wlX5737VRBzufcHJOyML/3.1.2.27%20Explorer.png" alt=""><figcaption><p>Explorer full view</p></figcaption></figure>

d) The KPI Explorer full view is shown below. Let's minimize the toolbar to maximize real estate. Click on the highlighted arrow and select 'Unpin toolbar'.&#x20;

<figure><img src="https://content.gitbook.com/content/sB9HAei8v4FfKkH9M4gw/blobs/KpEC4N8tZ9RXxH7Zu9Pa/3.1.2.28%20Explorer.png" alt=""><figcaption><p>KPI Explorer full view</p></figcaption></figure>

e) The toolbar gets unpinned. Turn the 'Filter by date' toggle on.

<figure><img src="https://content.gitbook.com/content/sB9HAei8v4FfKkH9M4gw/blobs/uWVTg3xhPR2hDmGGriRF/3.1.2.29%20Explorer.png" alt=""><figcaption><p>KPI Explorer</p></figcaption></figure>

f) The date filter slider gets enabled. The explorer toolbar consists of the following filters.&#x20;

<figure><img src="https://content.gitbook.com/content/sB9HAei8v4FfKkH9M4gw/blobs/be4fCtTG0yoAAhC9OpBN/3.1.2.30%20Explorer.png" alt=""><figcaption><p>Row, column, measure and date filters</p></figcaption></figure>

### 3. Filtering

Let's take a look at filtering by the row and column hierarchies.&#x20;

a) Use the date filter slider to define a date range. Select a region and category. In the table, you can now see only International and Beverages for Q3 2020 to Q2 2021.

<figure><img src="https://content.gitbook.com/content/sB9HAei8v4FfKkH9M4gw/blobs/E2itMPL5Rwe1Ki3WPtp4/3.1.2.31%20Explorer.png" alt=""><figcaption><p>Filtering rows and columns</p></figcaption></figure>

b) You can also see that the sub-region and sub-category get filtered accordingly in the explorer menu.&#x20;

<figure><img src="https://content.gitbook.com/content/sB9HAei8v4FfKkH9M4gw/blobs/Nf1YQoXfrpv6NIrXpjv4/3.1.2.32%20Explorer.png" alt=""><figcaption><p>Menu gets filtered</p></figcaption></figure>

c) Clear the selections by clicking on the highlighted arrow and then the 'Clear all' option.

<figure><img src="https://content.gitbook.com/content/sB9HAei8v4FfKkH9M4gw/blobs/SgJRMQUn2DgO8Rsa71q4/3.1.2.6(2)%20Explorer.png" alt=""><figcaption><p>Clearing selections</p></figcaption></figure>

d) As you can see, there is a value against each hierarchy. Let's look at how the values are calculated. Since the measure selected in the dropdown is 'Actuals', you can see the actuals value for All and United States highlighted as (1) and (2).

<figure><img src="https://content.gitbook.com/content/sB9HAei8v4FfKkH9M4gw/blobs/0bFQtxvqx862Vj7UNFKA/3.1.2.7(2)%20Explorer.png" alt=""><figcaption><p>Actuals for All and United States</p></figcaption></figure>

{% hint style="info" %}
Turn on the 'Column grand total' from the 'Totals' menu.
{% endhint %}

e) As shown in the below image, you can see the values highlighted in the case of the sub-regions.

<figure><img src="https://content.gitbook.com/content/sB9HAei8v4FfKkH9M4gw/blobs/ccDheCuRrDY4CdAzgPsE/3.1.2.8%20Explorer.png" alt=""><figcaption><p>Actuals for sub-regions</p></figcaption></figure>

f) To verify the values for categories and sub-categories, change the order of row and column hierarchies in the data mapping. That is assign Category and Sub category as 'Rows' and Region and Sub region as 'Columns' in the 'Visualizations' pane.

<figure><img src="https://content.gitbook.com/content/sB9HAei8v4FfKkH9M4gw/blobs/0jG6YN52h8oIyxvVFXDO/3.1.2.10%20Explorer.png" alt=""><figcaption><p>Actuals for categories and sub-categories</p></figcaption></figure>

<figure><img src="https://content.gitbook.com/content/sB9HAei8v4FfKkH9M4gw/blobs/QiLaNTjFnxOaDt9wWuPe/3.1.2.11%20Explorer.png" alt=""><figcaption><p>Actuals for categories and sub-categories</p></figcaption></figure>

g) You can also explore other measures. Click on the dropdown highlighted and select 'Plan'.

<figure><img src="https://content.gitbook.com/content/sB9HAei8v4FfKkH9M4gw/blobs/dZdv0XqLBD9YinrIx2LS/3.1.2.12%20Explorer.png" alt=""><figcaption><p>Exploring different measures</p></figcaption></figure>

h) The values get updated accordingly. As you can see, the values add up to 890.60 in all four hierarchies.

<figure><img src="https://content.gitbook.com/content/sB9HAei8v4FfKkH9M4gw/blobs/V61U1VCBHs8knU3RjaEE/3.1.2.13%20Explorer.png" alt=""><figcaption><p>Exploring Plan for regions</p></figcaption></figure>

i) When you apply filters, let's explore how the values are displayed. Select 'International'. The values for APAC and EMEA are shown as highlighted. Similarly, the values for subcategories can be verified.

<figure><img src="https://content.gitbook.com/content/sB9HAei8v4FfKkH9M4gw/blobs/E64SfNfCHIKH3LqzM7Mh/3.1.2.35%20Explorer.png" alt=""><figcaption><p>Values for subregions</p></figcaption></figure>

j) As you expand the sub-regions to reveal the categories, you can see that sum of plan values for beverages in APAC and EMEA is displayed.&#x20;

<figure><img src="https://content.gitbook.com/content/sB9HAei8v4FfKkH9M4gw/blobs/NmK4DXwAHIH2MN0bEDgK/3.1.2.36%20Explorer.png" alt=""><figcaption><p>Values for categories</p></figcaption></figure>

k) The date filter slider toggle can be turned off to list the date hierarchy as filters.&#x20;

<figure><img src="https://content.gitbook.com/content/sB9HAei8v4FfKkH9M4gw/blobs/11o9qVgbQrM4FypJbSId/3.1.2.15%20Explorer.png" alt=""><figcaption><p>Date filter</p></figcaption></figure>

### 4. Customizations

a) To hide certain KPIs, click on the arrow highlighted and the 'Show KPI' option.

<figure><img src="https://content.gitbook.com/content/sB9HAei8v4FfKkH9M4gw/blobs/rlJo2mfEDNbc8qpgogyZ/3.1.2.16%20Explorer.png" alt=""><figcaption><p>Show/hide KPIs</p></figcaption></figure>

b) KPIs can be hidden as shown.

<figure><img src="https://content.gitbook.com/content/sB9HAei8v4FfKkH9M4gw/blobs/MY1cikmI7plr5dD68OTq/3.1.2.17%20Explorer.png" alt=""><figcaption><p>Hiding sub-categories and month</p></figcaption></figure>

c) Sorting can be done based on values or names. To sort the categories by values, click on the gripper icon and 'Sort by values'. Select 'Ascending'.

<figure><img src="https://content.gitbook.com/content/sB9HAei8v4FfKkH9M4gw/blobs/AO1ItPOE2uLZYiycMAI5/3.1.2.18%20Explorer.png" alt=""><figcaption><p>Sorting by name or values</p></figcaption></figure>

d) The categories are sorted in descending order (Z->A). You can see an icon as shown in the image that shows the applied sorting.

<figure><img src="https://content.gitbook.com/content/sB9HAei8v4FfKkH9M4gw/blobs/z3FNtzvt9nNWQawW7tp0/3.1.2.19(2)%20Explorer.png" alt=""><figcaption><p>Sorting by values</p></figcaption></figure>

e) You can apply highlighting rules to the KPIs. Click on the 'Flag' icon as shown. There are two options - Rules and Ranges. Let's apply based on a range. You can define ranges based on percentage values or numeric values. Let's go with the default. Click 'Apply'.

<figure><img src="https://content.gitbook.com/content/sB9HAei8v4FfKkH9M4gw/blobs/PEBeqHOFLFIW7HdsxwGi/3.1.2.20(2)%20Explorer.png" alt=""><figcaption><p>Highlighting using rules or ranges</p></figcaption></figure>

f) The values get highlighted as shown. The flag icon is also modified to indicate that highlights have been applied.

<figure><img src="https://content.gitbook.com/content/sB9HAei8v4FfKkH9M4gw/blobs/dCSQua70rPflzkMSw4tx/3.1.2.21%20Explorer.png" alt=""><figcaption><p>Highlights based on ranges</p></figcaption></figure>

g) You can add ranges, reverse the icons and colors and delete ranges using the highlighted icons.

<figure><img src="https://content.gitbook.com/content/sB9HAei8v4FfKkH9M4gw/blobs/3SRBh8xGibhpzpKVo0rx/3.1.2.22%20Explorer.png" alt=""><figcaption><p>Customizing the ranges</p></figcaption></figure>

h) To 'reset' the ranges to default, click on the highlighted icon.

<figure><img src="https://content.gitbook.com/content/sB9HAei8v4FfKkH9M4gw/blobs/9LLNbxHAXYuYwgIIbdui/3.1.2.23%20Explorer.png" alt=""><figcaption><p>Reset changes</p></figcaption></figure>

i) Ranges based on numeric values are shown below.

<figure><img src="https://content.gitbook.com/content/sB9HAei8v4FfKkH9M4gw/blobs/0xEUM5wvU1CoQTOoQWiv/3.1.2.24%20Explorer.png" alt=""><figcaption><p>Range based on numeric values</p></figcaption></figure>

j) To apply highlights based on rules, select the 'Rules' option. Apply a rule as shown and click 'Apply'. The values are highlighted as shown.

<figure><img src="https://content.gitbook.com/content/sB9HAei8v4FfKkH9M4gw/blobs/8OwoEbMrZ26D9ZUcWnna/3.1.2.25%20Explorer.png" alt=""><figcaption><p>Highlights based on rules</p></figcaption></figure>

### 5. KPI header presets

Inforiver provides plug-and-play [header presets](https://docs.inforiver.com/premium-table/7.-paginated-reporting/header-and-footer#i-header-preset) to design your headers easily. If you have chosen the KPI preset, any selections made in the KPI explorer will be reflected in the header.

<figure><img src="https://content.gitbook.com/content/sB9HAei8v4FfKkH9M4gw/blobs/61dKuo4CoK29UFAfTpUE/Header%20-%20KPI%20explorer.png" alt=""><figcaption><p>KPI explorer filters reflected in KPI header preset</p></figcaption></figure>

In the next section, we'll cover [Top N](https://docs.inforiver.com/premium-table/working-with-premium-table/3.-basic-interactions/explore-and-filter-data/top-n) analysis.

#### Resources

[Explore data using Inforiver](https://inforiver.com/explore-data-powerbi/)