Step-by-Step Guide: Using Charts to Control Filters in SAP Analytics Cloud’s Analytic Applications

By Hadrian Parker
11/16/2023

Table of Contents

So, you are using Input Controls in order for end-users to be able to filter the results of their story. Though these are great features, sometimes they take up too much room within your story. Sometimes it would be more effective if the end-user could directly select a value on a chart or table and then have the rest of the story display filtered data for their selection. 

The following story has a table showing the revenue for 4 states in the USA:

It also has a chart showing the production cost, and a tables with the total cost and sales for each part sold.

The following text displays dynamic text for the dimension State:

We want the end-user to select states in the first chart, and have the entire page filtered to those states. Linked Analysis is a feature in SAC to do just this.

Want to dive deeper into Linked Analysis and Smart Features in SAP Analytics Cloud? Discover more about our comprehensive course within the Intermediate SAC Developer learning path. Learn more here.

Steps

  1. Enter Edit mode on your story.
  2. Select the first chart showing the states.
  3. Select the More option, to the right of the chart.
  4. Select More Options, then Linked Analysis.

A new Panel will open on the left.

Interactions apply to:

Your first setting is to decide which widgets in your story are affected by the selection.

We wish to specify which widgets will be selected.

 5. Select the option: Only Selected Widgets.
 6. Select Widgets to show available widgets.
 7. As we wish to affect all the widgets on this page, check all three.
 8. Click OK.

Note: You could also select All Widgets on the Page in this instance

Settings:

The Settings section has two options

  • The first will automatically add new widgets that are created to the list of affected widgets.
  • The second option, when selected, will mean that selections made on the chart are used as the filter.

  9. Select, Filter on Data Point Selection.
 10. Remember to click Apply.

Now we can test it out.

 11. Select a bar on the State per Region bar chart.

The unselected bars will be greyed out, and the Values for the other chart and the table will have changed to show your selection. The text has also changed to show only the state selected.

 12. While the first state is selected, select another state.

Here you can see that multiple selections can be made.

 13. To unselect click on the bar again, or to select all click on a blank part of the chart.

Ready to take your SAP Analytics Cloud skills to the next level and unlock the potential of Linked Analysis and Smart Features? Check out our course within the Intermediate SAC Developer learning path here. Take your data integration skills to the next level and create dynamic analytics applications. For more information and enrollment details, contact us at info@analysisprimeuniversity.com. Don’t miss out on this opportunity to enhance your data analysis capabilities!

Related Posts

Quarterly Release Cycle

May 22 2024

Planning Trigger – updated formatting options formats

You now have the capability to establish and save default styling preferences for planning triggers. In addition, you can design the triggers using vector

Arthur Phung

Quarterly Release Cycle

May 22 2024

Design Pane Header Re-design

The design panel has separate icons for Tables, Data Action Triggers, and Data Source. The data source name and the table name for tables

Nesha Holmes

Quarterly Release Cycle

May 22 2024

Refresh Selected Functions

Excel Add-in – Refresh Selected Functions For any function available in Excel workbook, you can select and refresh a portion of your function in

Arthur Phung

Contact Us

Reach out if you have any questions or to see how we can create a custom training solution for your organization!

Contact Form Pop-Up - General Use

Custom Training Solution

Fill out and submit the form below, and we’ll reach out to you to discuss how we can work toward achieving your training goals in a way that works best for you and your team.

Contact Form - Custom Training