https://community.qlik.com/t5/QlikView/average-of-a-sample/m-p/1817915#M1213177 <P>I have a sample of data calculated by taking a sum every day over a date range. I need an average of this and using&nbsp;avg(TOTAL aggr(sum(NoEpisodeError),LoadDate)) have done so with no problem.</P><P>However what I need to do now is get an average in the same table but only over a certain subset of those dates., and I cannot work out how to do it.&nbsp;</P><P>progress so far is below. can anyone make any suggestions please?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="steveniow_0-1624625296037.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/57554iFC6D78D4A887F46E/image-size/medium?v=v2&amp;px=400" role="button" title="steveniow_0-1624625296037.png" alt="steveniow_0-1624625296037.png" /></span></P><P>&nbsp;</P> Fri, 25 Jun 2021 12:49:13 GMT steveniow 2021-06-25T12:49:13Z https://community.qlik.com/t5/QlikView/average-of-a-sample/m-p/1817915#M1213177 <P>I have a sample of data calculated by taking a sum every day over a date range. I need an average of this and using&nbsp;avg(TOTAL aggr(sum(NoEpisodeError),LoadDate)) have done so with no problem.</P><P>However what I need to do now is get an average in the same table but only over a certain subset of those dates., and I cannot work out how to do it.&nbsp;</P><P>progress so far is below. can anyone make any suggestions please?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="steveniow_0-1624625296037.png" style="width: 400px;"><img src="https://community.qlik.com/t5/image/serverpage/image-id/57554iFC6D78D4A887F46E/image-size/medium?v=v2&amp;px=400" role="button" title="steveniow_0-1624625296037.png" alt="steveniow_0-1624625296037.png" /></span></P><P>&nbsp;</P> Fri, 25 Jun 2021 12:49:13 GMT https://community.qlik.com/t5/QlikView/average-of-a-sample/m-p/1817915#M1213177 steveniow 2021-06-25T12:49:13Z