Aggregated Waterfall Chart with two measures in SAS VA

[dishen_pancholi]

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

[Stu_SAS]

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! 

[dishen_pancholi]

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

[acordes]

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.