BookmarkSubscribeRSS Feed
☑ This topic is solved. Need further help from the community? Please sign in and ask a new question.
BijZuiderduin
Fluorite | Level 6

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?

Knipsel.PNG

 

Aantal is the measured variable

(Frequencypercentage cannot be used here.)

 

Thanks for suggestions.

Jurgen

 

 

 

1 ACCEPTED SOLUTION

Accepted Solutions
Madelyn_SAS
SAS Super FREQ

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

View solution in original post

10 REPLIES 10
Madelyn_SAS
SAS Super FREQ

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

CarolaRoettig
SAS Employee

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
Calcite | Level 5

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
SAS Employee

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

acordes
Rhodochrosite | Level 12

there is a possibility to achieve this:

a customized format that you can load to VA

BrunoMueller
SAS Super FREQ

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.

Bruno_SAS_0-1649854884917.png

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
Fluorite | Level 6
This looks promising! Depending on time available, I am going to give it a try.
JustinCase
Fluorite | Level 6

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
SAS Super FREQ

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.

 

BrunoMueller_0-1716792090752.png

Are you doing something different?

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 25. Read more here about why you should contribute and what is in it for you!

Submit your idea!

Tips for filtering data sources in SAS Visual Analytics

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.

Discussion stats
  • 10 replies
  • 4536 views
  • 5 likes
  • 8 in conversation