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

Solved
Occasional Contributor
Posts: 11

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: 131

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

[ Edited ]
Posted in reply to juliamorgan

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.

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

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

[ Edited ]
Posted in reply to juliamorgan

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