topic Re: How to change the format in VA in a 100% stacked bar chart in SAS Visual Analytics

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

BijZuiderduin — Fri, 08 Apr 2022 09:52:38 GMT

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

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

Madelyn_SAS — Fri, 08 Apr 2022 13:25:50 GMT

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

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

BijZuiderduin — Fri, 08 Apr 2022 21:21:24 GMT

Thank you!

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

acordes — Mon, 11 Apr 2022 07:26:45 GMT

there is a possibility to achieve this:

a customized format that you can load to VA

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

BrunoMueller — Wed, 13 Apr 2022 13:33:47 GMT

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

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

BijZuiderduin — Fri, 15 Apr 2022 16:12:06 GMT

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

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

CarolaRoettig — Mon, 23 May 2022 11:52:43 GMT

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

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

rshams — Tue, 04 Oct 2022 14:18:19 GMT

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.

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

JustinCase — Fri, 24 May 2024 11:40:56 GMT

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.

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

BrunoMueller — Mon, 27 May 2024 09:59:55 GMT

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?

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

MegSchaeffer — Wed, 09 Oct 2024 16:41:05 GMT

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

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

JustinCase — Fri, 17 Apr 2026 08:29:33 GMT

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

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

BrunoMueller — Tue, 21 Apr 2026 06:52:07 GMT

You are welcome and thanks for the feedback.