Hero Backgroud Elements 2
Reading Time: 3 Min

Create Dynamic Dashboards with Filter and Input Control

September 30, 2020


Input Controls SAP Analytics Cloud

As you create your Story, you may want certain information to be readily accessible, but not necessarily displayed at all times. Input Controls allow you to do just this — they allow you to filter data, compare figures, and explore relationships.

Essentially, Input Controls allow you to optimize the space on your dashboard and condense a lot of storytelling potential cleanly and more concisely.

In this post, we discuss a few scenarios for how Input Controls can add value to your analytics story.


Creating an Input Control

In our dataset, we have Sales Managers selling products in different regions. This alone could potentially produce dozens, or hundreds, of separate charts. Creating and analyzing all these charts is not only inefficient, but impractical.

Instead, we can create one chart and use an Input Control so that we can filter the chart depending on the region we want to see. For example, if we want to see which Sales Manager sells the most in Los Angeles, we can open our Input Control, expand the state of California, and select Los Angeles from the list.

How to create an Input Control:

  1. Select the chart that you would like to add an Input Control to
  2. Select the Input Control icon from the toolbar
  3. Choose the measure or dimension you would like to filter

Input Controls SAP Analytics Cloud

For this example, we want to select Dimensions > Location. A dialog appears allowing us to select the exact locations we want to include in our Input Control.

Input Controls SAP Analytics Cloud

When you’re finished, click OK. Your Input Control will appear on the canvas. You can move it, resize it, or restyle it as desired.

As you select different inputs from the Input Control panel, your chart changes to reflect those selections.

Input Controls can also be created in the Builder panel.


Creating a Measure Input Control

To create a measure Input Control, simply select ‘+ Add Measure’ > ‘+ Create Measure Input Control’.

Input Controls SAP Analytics Cloud

In the New Measure Input Control window, you can select from the available measures.

Input Controls SAP Analytics Cloud

This allows you to quickly cycle through the relevant measures depending on what information you want to see in your chart. If you want to see Quantity Sold, for instance, then you can select the Quantity Sold measure from the list. You can select more than one measure.

Measure Input Controls can be added to charts or tables, and can be reused in other charts and tables. For tables, the Input Control impacts a single column or row and supports calculated dimensions.


Input Controls for Other Occasions

Input Controls aren’t just limited to locations, they can be used for any measure or dimension in your dataset such as time, product category, employees, etc.

We’ll show you a few different scenarios for using Input Controls, the first being a really effective method of comparing the sales trends of two Sales Managers.

Input Controls SAP Analytics Cloud

First, you’ll want to create a time-series chart, then add an Input Control for all your employees.

Now, you can select all the employees you wish to compare, or choose a single employee if you wish to focus on that individual’s performance.

Another scenario where you can use an Input Control is to create a date range slider bar.

From the Input Control menu, select Date as the dimension, then choose ‘Filter by Range’.

Input Controls SAP Analytics Cloud

In the range selector, we can choose our range. In this case, we’ll filter by month from January 2013 to December 2015. This gives us the option to control the filter within the entire range of our dataset.

Input Controls SAP Analytics Cloud

Now, with our Input Control, we can use the slider to control the range. As we adjust the filter, the corresponding measure in our chart changes.

Input Controls SAP Analytics Cloud

Advanced Filters

Continuing with our previous example, we can set additional filters. Suppose we want to compare Janet Bury with Kiran Raj, but restrict our analysis to only alcohol sales in the state of California.

We can do that with the advanced filtering option.

Input Controls SAP Analytics Cloud

When we select advanced filtering, we have options to further refine our Input Controls.

Input Controls SAP Analytics Cloud

Here we are creating a condition to restrict the data to only show alcohol sales.

Next, we can create another condition for location. In our example, we want to compare alcohol sales in California. We can follow the same workflow as we did for alcohol and isolate California from the list.

The result is two conditions that look like this.

When we press OK and return to our story, we see that the data in our chart has been filtered.

Input Controls SAP Analytics Cloud

Story Filters

The next scenario we’ll show you is a really powerful way to sync all your charts and tables to one Input Control. This is known as a story-wide filter.

To do this, select the Input Control, and then select the ‘Covert to Story Filter’ icon.

Input Controls SAP Analytics Cloud

This creates a filter that affects all the charts in your story. When you click on one of the inputs, your entire story changes to adhere to that filter.

Input Controls SAP Analytics Cloud

You can also create a linked analysis to achieve the similar result as a story-wide filter.

Input Controls are an effective way to use one space for displaying a lot of information as well as for linking charts — perfect for ad hoc analyses.

Additional Resources