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,
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!
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
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.
Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.
If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website.
See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.