1 Reply Latest reply: May 22, 2018 4:15 PM by Giovanne Bergstein RSS

    Average excluding outliers using set analysis

    Gregory Buron

      Hi - I am trying to find the average call duration "CalldurationSeconds" excluding outliers.  Similar to the trimmed mean function in excel.  I believe that using set analysis would be the best bet but open to other suggestions.  Thanks!

       

      this is the current expression for the simple average:

       

      Avg(CallDurationSeconds)