Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Couple of questions. What type of chart object you are using & what is your Dimension.
As per my understanding the question, you need to calculate total call duration if call length more than sigma (avg(Length)+stdev(Length)) for each Request (SR) please find below:
vSigma = avg(Length) + stdev(Length)
or
vSigma = avg({1}Length) + stdev({1}Length) // Ignores current selection
Sum({<Lenghth={">=$(vSigma )"}>} Length)
Please share the sample data to answer your question.
I have my data in a Simple Table and have all of my fields as a dimension.