Can you add a dynamic variance in SAC Analytical Application

[former_member744964]

I built an application within the Analytical Application Designer.

We have a chart with only one keyfigure. The keyfigure which defines the output of the chart is selected via a radio button. The options within the radio button group are YTD (year to date) and MTD (month to date).
So our chart either shows YTD or MTD. We compare these values to those of the same period of the previous year and want to visualize these via a variance.

Our problem is, we can't manage to implement this via the Analytical Application Designer. We can define the variance in the chart options but only for one keyfigure. We can't set it up, so it changes dynamically, depending on which keyfigure the chart uses.

Thanks in regard,
Ömer.

[saurabh_sonawane · Accepted solution]

Hi,

Try this

we have to create 2 charts one for YTD and one for MTD (base on the radio button switch the chart)

And to add dynamic variance in the chart we need to use a Chart feed to change the measure dynamic in the chart so variance can also be calculated dynamically.

The below link will help to select the proper chart feed.

https://blogs.sap.com/2020/07/15/chart-and-feed-in-sap-analytics-cloud-analytics-designer/

Thanks,

Saurabh S.

[former_member744964 · Accepted solution]

This is a very obvious solution and I can't believe I haven't figured this out by myself. Thank you very much.