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,
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.
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.
Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.
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.