topic Average excluding outliers using set analysis in App Development https://community.qlik.com/t5/App-Development/Average-excluding-outliers-using-set-analysis/m-p/74869#M4960 <HTML><HEAD></HEAD><BODY><P>Hi - I am trying to find the average call duration "CalldurationSeconds" excluding outliers.&nbsp; Similar to the trimmed mean function in excel.&nbsp; I believe that using set analysis would be the best bet but open to other suggestions.&nbsp; Thanks!</P><P></P><P>this is the current expression for the simple average:</P><P></P><P>Avg(CallDurationSeconds) </P></BODY></HTML> Tue, 22 May 2018 17:43:16 GMT Anonymous 2018-05-22T17:43:16Z Average excluding outliers using set analysis https://community.qlik.com/t5/App-Development/Average-excluding-outliers-using-set-analysis/m-p/74869#M4960 <HTML><HEAD></HEAD><BODY><P>Hi - I am trying to find the average call duration "CalldurationSeconds" excluding outliers.&nbsp; Similar to the trimmed mean function in excel.&nbsp; I believe that using set analysis would be the best bet but open to other suggestions.&nbsp; Thanks!</P><P></P><P>this is the current expression for the simple average:</P><P></P><P>Avg(CallDurationSeconds) </P></BODY></HTML> Tue, 22 May 2018 17:43:16 GMT https://community.qlik.com/t5/App-Development/Average-excluding-outliers-using-set-analysis/m-p/74869#M4960 Anonymous 2018-05-22T17:43:16Z Re: Average excluding outliers using set analysis https://community.qlik.com/t5/App-Development/Average-excluding-outliers-using-set-analysis/m-p/74870#M4961 <HTML><HEAD></HEAD><BODY><P>It is possible to use an aggr function for aggregation, it follows</P><P></P><P>AVG (aggr (avg (CalldurationSeconds), ID))</P><P></P><P>Best Regards</P></BODY></HTML> Tue, 22 May 2018 20:15:08 GMT https://community.qlik.com/t5/App-Development/Average-excluding-outliers-using-set-analysis/m-p/74870#M4961 giovanneb 2018-05-22T20:15:08Z