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.

[MegSchaeffer]

I have a customer asking for this as well - LA County Public Health. Is there an update on this?

[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.

[JustinCase]

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.

[BrunoMueller]

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?

[JustinCase]

Hi Bruno,

I don't know if I do anything different. I could use your solution in another project and it works just fine. So thanks!

Kees

[BrunoMueller]

You are welcome and thanks for the feedback.