Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Getting Standard Deviation of task completion — Cloud Customer Connect
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!