You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Getting Standard Deviation of task completion

Received Response
11
Views
1
Comments
edited Feb 19, 2019 12:04AM in Reporting & Analytics for B2C Service 1 comment

Summary

Getting Standard Deviation of task completion

Content

Hi all,

I am getting Standard Deviation of task completion in TASKS table. I was intending to use STDDEV function but I have to use a table column as an expression for this function.This means I could not use this function. I have to get standard deviation for each account ID.

I can use below values:

- Average completion days : avg(date_diff(tasks.completed, tasks.created)/86400)

Square root(sum(power(average - date_diff(tasks.completed, tasks.created)/86400, 2)))

I would appreciate if you provide the formula to get Standard Deviation. Thanks.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!