BookmarkSubscribeRSS Feed
MikeFranz
Quartz | Level 8

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

 

 

1 REPLY 1
FredrikE
Rhodochrosite | Level 12

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

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 1 reply
  • 852 views
  • 0 likes
  • 2 in conversation