2 Replies Latest reply: Oct 22, 2015 4:01 PM by Jeremy Bohlke RSS

    Want my table to show values > Sigma (1 stddev from average)

      I have instances that keeps track of how long a phone call last (Length). I have configured sigma and want a table showing all of the phone calls > sigma.

       

      What is the formula I need to achieve this?

      SR stands for the Request, its the call ID

      Formula's I have tried:

       

      I created a Variable called Sigma =avg(Length)+stdev(Length)

       

       

      1.Sum({$<SR={"Length > {$(vSigma)}">}SR)

       

      2.Sum({$<SR={"Length >=avg(Length)+stdev(Length)">}SR)

       

      I want to just show the length of calls that are greater than Sigma. Seems easy enough but I am having troubles.

       

      Anything Helps!

       

      Thanks