ssnawaz Tracker
https://communities.sas.com/kntur85557/tracker
ssnawaz TrackerMon, 22 Apr 2024 10:21:08 GMT2024-04-22T10:21:08ZRe: Aggregated measure to measure
https://communities.sas.com/t5/SAS-Visual-Analytics/Aggregated-measure-to-measure/m-p/446021#M9712
<P>I have a custom graph made of both Scatter plot and Line graph(Line graph runs in both x axis and y axis).</P><P>The Problem or solution i require is for the line graph.</P><P>In the line graph (for now lets only consider x axis):</P><P>Line graph needs to show the average.</P><P>The variables needed is already calculated using aggregate measure [i.e., (Group by)P values / (group by All)Q values = XX]</P><P>So XX is the aggregated measure.</P><P>Now i want to calculate a simple average(ex: 20/10 = 2, So the average should be 2) which i can use in the line graph(created in custom graph).</P><P>Now when i use the - Avg(XX) in aggregated measure, i cant do that as SAS VA says i cant use an aggregated function).</P><P>So i am looking for solution for this.</P><P> </P><P>Thanks. </P>Thu, 15 Mar 2018 23:02:25 GMThttps://communities.sas.com/t5/SAS-Visual-Analytics/Aggregated-measure-to-measure/m-p/446021#M9712ssnawaz2018-03-15T23:02:25ZAggregated measure to measure
https://communities.sas.com/t5/SAS-Visual-Analytics/Aggregated-measure-to-measure/m-p/446007#M9710
<P>Hi,</P><P> </P><P>How to convert an aggregate measure to measure value.</P><P> </P><P>Thanks,</P><P>Nawaz.</P>Thu, 15 Mar 2018 21:31:18 GMThttps://communities.sas.com/t5/SAS-Visual-Analytics/Aggregated-measure-to-measure/m-p/446007#M9710ssnawaz2018-03-15T21:31:18ZRe: Calculate Average from an Aggregated Measure - SAS VA
https://communities.sas.com/t5/SAS-Visual-Analytics/Calculate-Average-from-an-Aggregated-Measure-SAS-VA/m-p/445640#M9687
<P>Hi Ballardw,</P><P> </P><P>Thanks for your quick response.</P><P> </P><P>I am building custom graph with - a scatter plot(to show various sectors) and also a line graph inside it(both x and Y axis) to show their average.</P><P> </P><P>So i have already done an aggregated measure(sum of Sector_PD(group)/sum of Sector_PD(All)) - Thats what gives me PD%.</P><P> </P><P>Now for me to put that in the graph, I need their Average.</P><P> </P><P>As i showed in my Previous File. I need to create a field called Avg_PD% as 7% based on the above.</P><P> </P><P>Thanks,</P><P>Nawaz. </P>Wed, 14 Mar 2018 20:59:12 GMThttps://communities.sas.com/t5/SAS-Visual-Analytics/Calculate-Average-from-an-Aggregated-Measure-SAS-VA/m-p/445640#M9687ssnawaz2018-03-14T20:59:12ZCalculate Average from an Aggregated Measure - SAS VA
https://communities.sas.com/t5/SAS-Visual-Analytics/Calculate-Average-from-an-Aggregated-Measure-SAS-VA/m-p/445636#M9685
<P>Hi,</P><P> </P><P>I have an aggregated Measure (PD%)</P><P>Now i want the Average of that Aggregated Measure.</P><P>How do i do that. Im kind of Stuck.</P><P> </P><P>Thanks,</P><P>Nawaz.</P>Wed, 14 Mar 2018 20:41:52 GMThttps://communities.sas.com/t5/SAS-Visual-Analytics/Calculate-Average-from-an-Aggregated-Measure-SAS-VA/m-p/445636#M9685ssnawaz2018-03-14T20:41:52Z