SAC Story: How to filter a chart on another page based on pie-chart segment selection?

[SKSKumar]

Hi SAC 

I am working on an SAC Story with two separate pages:

• Page 1: A pie chart showing Material-wise values

• Page 2: A column chart showing monthly values (Jan, Feb, Mar, Apr...) for each material

I want this behavior:

When a user selects a segment of the pie chart on Page 1 (i.e., selects a Material or multiple material), the column chart on Page 2 should automatically update and show the corresponding monthly values for that selected material.

Keeping both charts on the same page is not an option in my case.

Is there any way to achieve this in an SAC Story—either through Linked Analysis, Story Filters, Input Controls, or any other method?
If this is only possible through scripting, please help me with the script. 

Thank you

[KannanR · Accepted solution]

Adding to Michael’s answer Linked Analysis is indeed a good approach.

I would also like to mention another option that can improve the user experience:

Use a Hyperlink with Filters to Jump to the Second Page

You can add a Hyperlink to the pie chart that:

• Navigates directly to Page 2

• Automatically applies the selected Material as a filter on that page

This way, when a user clicks a slice of the pie chart, they are taken straight to the monthly view with the correct Material already filtered.

Steps (shown in screenshots):

1. Right-click the chart → More Options → Add → Hyperlink

2. Set “Link To” as Page, and choose Page 2

3. Enable Apply Selected Dimension as a Filter

4. (Optional) Enable Cascading Effect if you want other filters to be respected

This provides a smooth drill-down experience between pages where the user would feel like they start at a slice of pie and then navigate to a deeper analysis for that slice of pie. 

Then in view mode: the user can use the "Jump to" option that appears when clicking on slice of pie.

That will take them to the first page with the filters applied. 

[SKSKumar · Accepted solution]

Thank you — this worked well for us, especially for navigating back and forth between pages. The hyperlink option is somewhat hidden in SAP and not easily visible to users

[MichaelRuzicic]

Hey @SKSKumar 

This is absolutely possible! Just add Linked Analysis to the chart and in the settings proceed choose "all widgets in the story" or if you want the pie chart to only affect one specific chart, choose the option "only selected widgets". 

I hope this helps you out!

Kind Regards,
Michael