In VA I created a 100% stacked bar chart with labels per segment.
The percentage value is shown with 2 decimals. How can this be changed to 1 decimal?
Aantal is the measured variable
(Frequencypercentage cannot be used here.)
Thanks for suggestions.
Jurgen
You cannot change the number of decimal places, but I have added you to the list of customers requesting this ability.
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center
You cannot change the number of decimal places, but I have added you to the list of customers requesting this ability.
-------------------------------------------------------------------------
Four tips to remember when you contact SAS Technical Support
Tricks for SAS Visual Analytics Report Builders
SAS Visual Analytics Learning Center
is there an open feature request for this?
i also have a customer ("Versicherungskammer Bayern") who is asking for this option.
regards,
Caro
PS: THanks, Bruno, for this great trick!!
I would like this feature to be added as well. I have a bar chart showing 8 decimal places right now which does not look nice. There should be a way to customize the decimal places on display on the charts.
I have a customer asking for this as well - LA County Public Health. Is there an update on this?
there is a possibility to achieve this:
a customized format that you can load to VA
You can achieve the percent with 1 decimal by calculating the values with new dataitems, this will allow you to specify the format you want to use.
Here is a screenshot comparing the two methods.
The example uses sashelp.cars and the following dataitems:
hp by type:
AggregateTable(_Sum_, Table(_Sum_, Fixed('Type'n), 'Horsepower'n))
hp aggr:
Sum [_ByGroup_] ('Horsepower'n)
hp aggr / hp by type %:
'hp aggr'n / 'hp by type'n
The barchart to the left uses the "Normalize groups to 100%"
The barchart to the right uses the calculated dataitem "hp aggr / hp by type %"
Nice solution, but it has one downside. In the normailzed group version, I can create an action to either group, with the calculated measure of Bruno unfortunately I can't.
So I would prefer a solution in which I can choose the format of the grouped percentages.
I do not understand the question.
The bar chart to the left uses the "normalize groups to 100%", it filters the list table below using an action.
The bar chart to the right uses the technique with the calculated data items as described above, it filters the list table below.
Are you doing something different?
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
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.