BookmarkSubscribeRSS Feed
rmalcata
Quartz | Level 8

Hi All,

 

this is a bit of a random question.

 

I am interested in selecting the data that is displayed in a graph using lists. Because this list, have several levels, in the ideal world the user could use something like this:

 

example of sublist.PNG

 

However, I do not think SAS VA currently allows for this.

 

So far I have two alternatives.

1- Multiple lists one for each level. It just gets a bit messy for the user to know what value is within each level.

2- Cross tab and hierarchy. This way the user can drill down to the different levels and by clicking in the number (measure), the filter will be activated. Although, this produce somehow the outcome, it would ideal to have something prettier, clear and easier to use (particular when you want to select multiple values within different levels of a list).

As I said, it is a bit of a random request.

 

Cheers,
Rita

2 REPLIES 2
FredrikE
Rhodochrosite | Level 12

I would go for the first one with multiple lists, one for each level and create interactions between them so that the sublists filters due to the selections in the lists above.

 

I have tried the cross tab, but as you say it a bit clumsy to use just for selection of the data.

 

//Fredrik

rmalcata
Quartz | Level 8

Thanks Fredrik.
I will show both to the user and let him decide what he prefers. Definitely a case of cleaner or more functionality.

 

Cheers,

Rita

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!

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
  • 2 replies
  • 1361 views
  • 1 like
  • 2 in conversation