topic Re: Interactions in SAS Visual Analytics

Interactions

don21 — Fri, 26 Apr 2019 04:36:05 GMT

Dear all, I have a data set that might look like below:

Measure1 measure2 .... measure 20
10000000 22000000. 350000000

I have created a simple line chart with date hierarchy and I have created a dummy table with a column call measures and have put all the above measure names in it. I have used this dummy table to create a drop down list (checkbox)
Now the problem is I am not able to make this interaction work between line chart and the drop down.

I want to select the measure that I want and view their performance date wise.. any way that I can achieve this?

Re: Interactions

FredrikE — Fri, 26 Apr 2019 10:47:08 GMT

Hi!

I think it look like the same problem as described in this post:

https://communities.sas.com/t5/SAS-Visual-Analytics/Drop-down-in-SAS-VA/td-p/552776

//Fredrik

Re: Interactions

don21 — Sat, 27 Apr 2019 18:16:17 GMT

Thank you!

What I have done is, I have created a dummy table with a column containing the names of measures

Then I have created the drop down.

For the interaction to work, I have created an empty parameter and assigned it to both the line chart and the drop down and then I have created an aggregated measure with this parameter and wrote the formula if parameter name= measure name, return measure

This worked perfect!!