How to change the format in VA in a 100% stacked bar chart

[BijZuiderduin]

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

[Madelyn_SAS · Accepted solution]

You cannot change the number of decimal places, but I have added you to the list of customers requesting this ability. 

[BijZuiderduin]

Thank you!

[CarolaRoettig]

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!!

[rshams]

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.

[acordes]

there is a possibility to achieve this:

a customized format that you can load to VA

[BrunoMueller]

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 %"

[BijZuiderduin]

This looks promising! Depending on time available, I am going to give it a try.