https://communities.sas.com/t5/SAS-Visual-Analytics/Formula-calculation/m-p/718556#M14644 <P>Hello,<BR />Does anyone knows the formula used to calculate ‘Normalise groups to 100%’ in the Group Scale which is found under Option in SAS Visual Analytics 8.5?</P><P>Thanks Catherine</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="cokello_0-1613045871516.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/54573iD467B296BD6B06CE/image-size/medium?v=v2&amp;px=400" role="button" title="cokello_0-1613045871516.png" alt="cokello_0-1613045871516.png" /></span></P><P>&nbsp;</P> Thu, 11 Feb 2021 12:19:35 GMT cokello 2021-02-11T12:19:35Z https://communities.sas.com/t5/SAS-Visual-Analytics/Formula-calculation/m-p/718556#M14644 <P>Hello,<BR />Does anyone knows the formula used to calculate ‘Normalise groups to 100%’ in the Group Scale which is found under Option in SAS Visual Analytics 8.5?</P><P>Thanks Catherine</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="cokello_0-1613045871516.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/54573iD467B296BD6B06CE/image-size/medium?v=v2&amp;px=400" role="button" title="cokello_0-1613045871516.png" alt="cokello_0-1613045871516.png" /></span></P><P>&nbsp;</P> Thu, 11 Feb 2021 12:19:35 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Formula-calculation/m-p/718556#M14644 cokello 2021-02-11T12:19:35Z https://communities.sas.com/t5/SAS-Visual-Analytics/Formula-calculation/m-p/718872#M14651 <P>Hello&nbsp;<a href="https://communities.sas.com/t5/user/viewprofilepage/user-id/368919">@cokello</a>&nbsp;and welcome to the SAS Support Communities!</P> <P>&nbsp;</P> <P>I have never used Visual Analytics, but from the <A href="https://documentation.sas.com/?cdcId=vacdc&amp;cdcVersion=8.5&amp;docsetId=vaobj&amp;docsetTarget=n17j4927o8of5an1qf633jwjffbr.htm&amp;locale=en" target="_blank" rel="noopener">documentation</A></P> <BLOCKQUOTE> <P>If you select <STRONG>Normalize groups to 100%</STRONG>, then the values for each grouped bar are displayed as percentages of the total.</P> </BLOCKQUOTE> <P>I conclude that you would divide the individual values (≥0) by the sum of all values (≥0) in the same group and multiply by 100% to obtain percentages (summing to 100% in each group).</P> <P>&nbsp;</P> <P>In the example bar chart presented in the 2014 post&nbsp;<A href="https://communities.sas.com/t5/SAS-Visual-Analytics/100-Stacked-Bar-Charts/m-p/153326/highlight/true#M599" target="_blank" rel="noopener">Re: 100% Stacked Bar Charts</A>:</P> <P>If the revenues of the product lines A, B, C and D in facility region "South" are denoted by R<SUB>A</SUB>, R<SUB>B</SUB>, R<SUB>C</SUB> and R<SUB>D</SUB>, respectively, then the corresponding percentages p<SUB>A</SUB>, p<SUB>B</SUB>, etc. (depicted in the stacked bar chart as the heights of the blue, green, red and yellow section of the first bar) are calculated as</P> <UL> <LI>p<SUB>A</SUB>&nbsp;= 100% ∙ R<SUB>A</SUB>/(R<SUB>A</SUB>+R<SUB>B</SUB>+R<SUB>C</SUB>+R<SUB>D</SUB>)</LI> <LI>p<SUB>B</SUB> = 100% ∙ R<SUB>B</SUB>/(R<SUB>A</SUB>+R<SUB>B</SUB>+R<SUB>C</SUB>+R<SUB>D</SUB>)</LI> <LI>and so on</LI> </UL> <P>and similarly for the other three regions.</P> Fri, 12 Feb 2021 13:24:02 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/Formula-calculation/m-p/718872#M14651 FreelanceReinh 2021-02-12T13:24:02Z