Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Averaging the # of days open — 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

Averaging the # of days open

Accepted answer
19
Views
3
Comments
edited Oct 29, 2011 4:54PM in Reporting & Analytics for B2C Service 3 comments

Content

I have created a report where I am looking at incidents from a subset of our customers - I rollup this report by Customer Name and then Incident Severity and then calculate the number of days/hours to resolve using date_diff() - In order to have this display in Days/hours I am using the following definition:

time_format(date_diff(incidents.closed,incidents.created), 'DD Days HH24 Hours')

I then wish to average the number of days open per severity but the average is greyed out when using the time_format. I can average the date diff - but this gives me seconds and I want days/ hours.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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