Waterfall Chart wont accept numeric/measures

[Genoa]

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]

Hi @Genoa,

which Data role of the waterfall are you refering to?

(Image taken in VA 7.5)

Best

Markus

[Genoa]

HI Markus, its for the category data role

[MarkusWeick]

Hi @Genoa,

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

Best

Markus

[acordes]

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.

so 

Step1: binned_revenue=round(revenue, 100000) 

Step2 binned_revenue_cat=format(binned_revenue, best12.)

Step3: Use binned_revenue_cat as categorical variable

[Genoa]

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