topic Re: Waterfall Chart wont accept numeric/measures in SAS Visual Analytics

Waterfall Chart wont accept numeric/measures

Genoa — Fri, 29 Jul 2022 04:01:02 GMT

Hello Experts,

How come the waterfall chart in SAS Viya for Learners only accept categorial variable? I am trying to use it on profit and revenues.

Thanks for any help given.

MarkusWeick — Fri, 29 Jul 2022 06:33:55 GMT

which Data role of the waterfall are you refering to?

(Image taken in VA 7.5)

Best

Markus

acordes — Fri, 29 Jul 2022 08:11:33 GMT

Look at the structure, it's quite straightforward.

If you want to visualize revenue vs profit as a waterfall chart, you could convert revenue into categorical variable after binning it.

Step1: binned_revenue=round(revenue, 100000)

Step2 binned_revenue_cat=format(binned_revenue, best12.)

Step3: Use binned_revenue_cat as categorical variable

Genoa — Sat, 30 Jul 2022 02:42:39 GMT

HI Markus, its for the category data role

Genoa — Sat, 30 Jul 2022 02:44:24 GMT

thanks Acordes, I guess I have to do a conversion on the different cost measures (production cost, marketing cost, etc) as well?

MarkusWeick — Sat, 30 Jul 2022 07:34:43 GMT

for the category you need category variables. @acordes already showed, what you could do.

Best

Markus