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

[juliamorgan]

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,

[itchyeyeballs · Accepted solution]

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.