Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
MRitter
Employee
Employee

Standard Deviation

I need to calculate the average time between 2 dates and then calculate the average minus 1 standard deviation and then the average plus 1 standard deviation.

This is the expression I am using to calculate the average.

Avg(Aggr(DiscardTimeStamp - SubmittedTimeStamp, serviceRequestID))

This seems to work ok. 

Not sure how to calculate the STD and do the above?

Thanks

1 Solution

Accepted Solutions
jwjackso
Specialist III
Specialist III

Try the same formula replacing AVG with STDEV for the standard deviation.  Add/Subtract from the AVG value.

View solution in original post

1 Reply
jwjackso
Specialist III
Specialist III

Try the same formula replacing AVG with STDEV for the standard deviation.  Add/Subtract from the AVG value.