Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

VA Bar Chart - is there a way to have an interactive measure selection?

Accepted Solution Solved
Reply
Occasional Contributor
Posts: 11
Accepted Solution

VA Bar Chart - is there a way to have an interactive measure selection?

Hi,

I have two bar charts that each need to take up a full tab, but they both have the same information, only difference is one shows percentage and one shows the actual number.

 

Is there any way to have a button bar (or something else) so that I only need one tab / graph and report users can select whether they wish to view as a percentage or number?

 

Thanks,


Accepted Solutions
Solution
‎05-08-2017 06:35 PM
Frequent Contributor
Posts: 113

Re: VA Bar Chart - is there a way to have an interactive measure selection?

[ Edited ]

Hi, 

 

Yes you can, there are some examples in the following link that show how to use a parameter to achieve similar results 

 

http://blogs.sas.com/content/sgf/2015/01/29/using-parameters-in-sas-visual-analytics/

 

You would basically have a calculated item for percentage and a seperate one for count. A third calculated item would then select the one to use based on the parameter chosen by the user.

 

One problem I have encountered when doing the same thing is the format of the final calculated item is fixed, you can change the calulation based on the selected parameter but not the format, therefore percentages end up being dispalyed as 0.8 rather than 80%. someone out there may have a solution for that though.

View solution in original post


All Replies
Solution
‎05-08-2017 06:35 PM
Frequent Contributor
Posts: 113

Re: VA Bar Chart - is there a way to have an interactive measure selection?

[ Edited ]

Hi, 

 

Yes you can, there are some examples in the following link that show how to use a parameter to achieve similar results 

 

http://blogs.sas.com/content/sgf/2015/01/29/using-parameters-in-sas-visual-analytics/

 

You would basically have a calculated item for percentage and a seperate one for count. A third calculated item would then select the one to use based on the parameter chosen by the user.

 

One problem I have encountered when doing the same thing is the format of the final calculated item is fixed, you can change the calulation based on the selected parameter but not the format, therefore percentages end up being dispalyed as 0.8 rather than 80%. someone out there may have a solution for that though.

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 1 reply
  • 180 views
  • 1 like
  • 2 in conversation