topic Re: Using slider to set cutoff for grouped histogram in SAS Visual Analytics

Using slider to set cutoff for grouped histogram

Ullsokk — Wed, 23 Sep 2020 09:59:32 GMT

I am trying to create a histogram to show how the age distributions differ between customers in two groups, e.g. high and low probability of buying a product. Ideally, I want to use a slider to dynamically change the score cutoff, so that the user can see how the two distributions look for e.g. scores above\below 0.9, 0.5, etc. I have a more static HTML based report that illustrates the two different distribution, although for a fixed cutoff. Is there a way to create two groups based on a slider or other user input?

Re: Using slider to set cutoff for grouped histogram

Sam_SAS — Thu, 24 Sep 2020 13:38:55 GMT

Hello,

Did you try creating a slider that filters the histogram? If you assign your score variable to the slider, it seems like this should give you the desired result.

Or did you want your group variable to be defined by the slider setting? This could be accomplished by assigning a parameter to the slider and then creating a calculated measure based on that parameter.

Let us know if that helps, or if I am misunderstanding what you want to do. If you could show a row or two of your data, that would help us understand.

Thanks,

Sam

Re: Using slider to set cutoff for grouped histogram

Ullsokk — Fri, 25 Sep 2020 09:57:31 GMT

Yes, I want my group variable to be based on the slider setting.

Will try that out, thanks.

Re: Using slider to set cutoff for grouped histogram

Ullsokk — Fri, 25 Sep 2020 10:22:37 GMT

What would the calculated measure look like?

I assume something like if parameter < slider value then group 1 else group 2, but I can't quite see how to write in in VA

Re: Using slider to set cutoff for grouped histogram

Ullsokk — Fri, 25 Sep 2020 10:51:49 GMT

Figured it out:

The calculated item had to be

IF ( 'Scorevariable'n >= 'cutoff parameter'p )
RETURN 1
ELSE 0

Re: Using slider to set cutoff for grouped histogram

Sam_SAS — Fri, 25 Sep 2020 12:54:36 GMT

Great! Thanks for following up with us. 🙂

The calculated expression syntax in VA is a bit unusual, but it can be very useful.

Sam