Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
It is possible to use an aggr function for aggregation, it follows
AVG (aggr (avg (CalldurationSeconds), ID))
Best Regards