Hi,
I'm running SAS Visual Analytics 8.2.
I would like to do the following:
Create a button bar with several categories
Based on the selection in this button bar, change the "Rows" Data Role in a crosstab.
For example, imagine a button bar with two options, "State" and "City".
If the user selects "State" then the table would look like this:
State Cost
NC 100
TX 200
MN 150
If the user selects "City", then the table look like this:
City Cost
Charlotte 40
Raleigh 140
Dallas 200
Memphis 150
So, basically, the row aggregation has changed based on the selection in the button bar.
I found this link: https://blogs.sas.com/content/sgf/2016/04/27/use-parameters-to-pick-your-metric-in-visual-analytics-...
which shows how to select a measure based on user input, but I can't work out how to select a row.
Let me know if I can make the above clearer.
Thanks,
Mike
It should work the same as the example in the link.
Just change "selectedMeasureParameter" to "State" and "City" depending on the parameter.
Then use the calculated item on the rows role.
//Fredrik
Don't miss out on SAS Innovate - Register now for the FREE Livestream!
Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.
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.