https://community.qlik.com/t5/App-Development/The-Average-Function-Chart-result-differs-from-the-average-total/m-p/1723670#M55072 <P>I have a data set that shows, by assignee, the date that a service request was placed in a work queue.&nbsp; The table shows all the items in the queue, selectable by assignee.&nbsp; I've configured the table to return average number of backlog days:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="fginfrida_0-1593541037502.png" style="width: 544px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/36609i037500203570FB28/image-dimensions/544x173?v=v2" width="544" height="173" role="button" title="fginfrida_0-1593541037502.png" alt="fginfrida_0-1593541037502.png" /></span></P><P>Where the column Backlog Days is forced to be a measure by setting equal to Avg(Backlog_Day_Number). The query that generates a data set for this application returns a value for backlog days which is calculated excluding all non-working days.</P><P>The value of 8.9 for the particular assignee is correct - a total of 62 backlog days for 7 service requests.&nbsp; Well and good.</P><P>However, when I try to compute the backlog elsewhere in the application, either with the formula</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Aggr(Avg(Backlog_Day_Number),Assignee)&nbsp;</P><P>Or with a simple&nbsp;</P><P>&nbsp; &nbsp; &nbsp; &nbsp; Avg(Backlog_Day_Number) with a selection of "Charles Burrell"</P><P>the application returns 11.17.</P><P>Clearly I'm failing to understand something about the Avg. Function (and why it differs from selecting a Total with a type of Avg).&nbsp; Can anyone shed light on this?</P><P>Thanks,</P><P>Frank Ginfrida</P> Sat, 16 Nov 2024 02:00:50 GMT fginfrida 2024-11-16T02:00:50Z https://community.qlik.com/t5/App-Development/The-Average-Function-Chart-result-differs-from-the-average-total/m-p/1723670#M55072 <P>I have a data set that shows, by assignee, the date that a service request was placed in a work queue.&nbsp; The table shows all the items in the queue, selectable by assignee.&nbsp; I've configured the table to return average number of backlog days:</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="fginfrida_0-1593541037502.png" style="width: 544px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/36609i037500203570FB28/image-dimensions/544x173?v=v2" width="544" height="173" role="button" title="fginfrida_0-1593541037502.png" alt="fginfrida_0-1593541037502.png" /></span></P><P>Where the column Backlog Days is forced to be a measure by setting equal to Avg(Backlog_Day_Number). The query that generates a data set for this application returns a value for backlog days which is calculated excluding all non-working days.</P><P>The value of 8.9 for the particular assignee is correct - a total of 62 backlog days for 7 service requests.&nbsp; Well and good.</P><P>However, when I try to compute the backlog elsewhere in the application, either with the formula</P><P>&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Aggr(Avg(Backlog_Day_Number),Assignee)&nbsp;</P><P>Or with a simple&nbsp;</P><P>&nbsp; &nbsp; &nbsp; &nbsp; Avg(Backlog_Day_Number) with a selection of "Charles Burrell"</P><P>the application returns 11.17.</P><P>Clearly I'm failing to understand something about the Avg. Function (and why it differs from selecting a Total with a type of Avg).&nbsp; Can anyone shed light on this?</P><P>Thanks,</P><P>Frank Ginfrida</P> Sat, 16 Nov 2024 02:00:50 GMT https://community.qlik.com/t5/App-Development/The-Average-Function-Chart-result-differs-from-the-average-total/m-p/1723670#M55072 fginfrida 2024-11-16T02:00:50Z https://community.qlik.com/t5/App-Development/The-Average-Function-Chart-result-differs-from-the-average-total/m-p/1723673#M55074 <P>How about this?</P><LI-CODE lang="markup">Avg(Aggr( Avg(Backlog_Day_Number) , Assignee, [SR No.]))</LI-CODE><P>&nbsp;</P> Tue, 30 Jun 2020 18:33:13 GMT https://community.qlik.com/t5/App-Development/The-Average-Function-Chart-result-differs-from-the-average-total/m-p/1723673#M55074 sunny_talwar 2020-06-30T18:33:13Z https://community.qlik.com/t5/App-Development/The-Average-Function-Chart-result-differs-from-the-average-total/m-p/1727445#M55439 <P>Thank you.&nbsp; That provided a correct answer.</P><P>I'm still not clear on the rationale for the result. I'll have to dig deeper into the AVG function and how it operates.</P> Mon, 13 Jul 2020 18:38:22 GMT https://community.qlik.com/t5/App-Development/The-Average-Function-Chart-result-differs-from-the-average-total/m-p/1727445#M55439 fginfrida 2020-07-13T18:38:22Z