topic Re: How do I mix Actual Values and Normalize to 100 % in bar chart data tip in SAS Visual Analytics https://communities.sas.com/t5/SAS-Visual-Analytics/How-do-I-mix-Actual-Values-and-Normalize-to-100-in-bar-chart/m-p/777829#M15563 <P>Hmm.&nbsp;<BR />I wish I could do calculate item by both group and category&nbsp; so the freq would be more in line with what I Want.&nbsp;</P> <P>&nbsp;</P> Tue, 02 Nov 2021 07:21:04 GMT Pili1100 2021-11-02T07:21:04Z How do I mix Actual Values and Normalize to 100 % in bar chart data tip https://communities.sas.com/t5/SAS-Visual-Analytics/How-do-I-mix-Actual-Values-and-Normalize-to-100-in-bar-chart/m-p/776771#M15541 <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Pili1100_1-1635348034797.png" style="width: 400px;"><img src="https://communities.sas.com/t5/image/serverpage/image-id/65086iBB12C67EEA6DD128/image-size/medium?v=v2&amp;px=400" role="button" title="Pili1100_1-1635348034797.png" alt="Pili1100_1-1635348034797.png" /></span></P> <P>This is an exemple</P> <P>Data in these case is Sting values.<BR />Year month is The category&nbsp;</P> <P>Group is the grouping variable&nbsp;&nbsp;</P> <P>Freq is&nbsp;Frequency</P> Wed, 27 Oct 2021 15:21:05 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/How-do-I-mix-Actual-Values-and-Normalize-to-100-in-bar-chart/m-p/776771#M15541 Pili1100 2021-10-27T15:21:05Z Re: How do I mix Actual Values and Normalize to 100 % in bar chart data tip https://communities.sas.com/t5/SAS-Visual-Analytics/How-do-I-mix-Actual-Values-and-Normalize-to-100-in-bar-chart/m-p/776866#M15544 <P>Normalize and Actual are mutually exclusive options. You cannot mix them.&nbsp;</P> Wed, 27 Oct 2021 20:19:48 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/How-do-I-mix-Actual-Values-and-Normalize-to-100-in-bar-chart/m-p/776866#M15544 Madelyn_SAS 2021-10-27T20:19:48Z Re: How do I mix Actual Values and Normalize to 100 % in bar chart data tip https://communities.sas.com/t5/SAS-Visual-Analytics/How-do-I-mix-Actual-Values-and-Normalize-to-100-in-bar-chart/m-p/776870#M15546 Putting two separate bar charts side by side might be a way to show both values. Wed, 27 Oct 2021 20:56:16 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/How-do-I-mix-Actual-Values-and-Normalize-to-100-in-bar-chart/m-p/776870#M15546 Sam_SAS 2021-10-27T20:56:16Z Re: How do I mix Actual Values and Normalize to 100 % in bar chart data tip https://communities.sas.com/t5/SAS-Visual-Analytics/How-do-I-mix-Actual-Values-and-Normalize-to-100-in-bar-chart/m-p/777827#M15562 <P>yes, that usually work but I would be nice to only have one item instead of two&nbsp;<span class="lia-unicode-emoji" title=":smiling_face_with_smiling_eyes:">😊</span></P> <P>&nbsp;</P> <P>&nbsp;</P> Tue, 02 Nov 2021 07:19:54 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/How-do-I-mix-Actual-Values-and-Normalize-to-100-in-bar-chart/m-p/777827#M15562 Pili1100 2021-11-02T07:19:54Z Re: How do I mix Actual Values and Normalize to 100 % in bar chart data tip https://communities.sas.com/t5/SAS-Visual-Analytics/How-do-I-mix-Actual-Values-and-Normalize-to-100-in-bar-chart/m-p/777829#M15563 <P>Hmm.&nbsp;<BR />I wish I could do calculate item by both group and category&nbsp; so the freq would be more in line with what I Want.&nbsp;</P> <P>&nbsp;</P> Tue, 02 Nov 2021 07:21:04 GMT https://communities.sas.com/t5/SAS-Visual-Analytics/How-do-I-mix-Actual-Values-and-Normalize-to-100-in-bar-chart/m-p/777829#M15563 Pili1100 2021-11-02T07:21:04Z