topic Re: Aggregated Waterfall Chart with two measures in SAS VA in SAS Visual Analytics

Aggregated Waterfall Chart with two measures in SAS VA

dishen_pancholi — Wed, 30 Mar 2022 13:55:05 GMT

Hello Everyone,

I want to develop a waterfall chart that has measures on both the axis where i need to apply an aggregation on both the axis, is this possible in SAS VA and if yes how can I achieve that?

Thanks & Regards,

Dishen Pancholi

Re: Aggregated Waterfall Chart with two measures in SAS VA

Stu_SAS — Wed, 30 Mar 2022 16:38:21 GMT

Hey Dishen! With the Custom Graph Builder, you sure can. Let's make a custom waterfall chart with two axes: one for the waterfall, and one for a scatterplot. First, go to the hamburger menu and open up Custom Graph Builder:

In Graph Builder, drag a Waterfall chart and a Scatter Plot on top of each other:

Select the Options pane on the right and click the Scatter Plot. Change the Y axis to the right side:

Save your custom graph. Log on to Visual Analytics and import your custom graph from the location you saved it.

Drag it onto the canvas, add your roles, and you're all done!

Re: Aggregated Waterfall Chart with two measures in SAS VA

dishen_pancholi — Wed, 30 Mar 2022 23:07:19 GMT

Hello @Stu_SAS ,

Thank you so much for your reply, but is it possible to not have a category and just two measures for the chart, one on X-axis and one on Y-axis? My requirement is to have aggregated measure on both the axis which is not possible if I have a category on the X-axis

Re: Aggregated Waterfall Chart with two measures in SAS VA

acordes — Tue, 12 Apr 2022 21:43:29 GMT

I think you clearly misunderstand the concept of aggregation.

numeric vs numeric won't aggregate due to the lack of clear rules "where" to aggregate the other measure.

you can trick a measure into behaving like a category by using the format in create calculated item.