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!