madmilitia

Forum Replies Created

Viewing 9 posts - 1 through 10 (of 10 total)

RE: carving out bussiness hours.

DesNorton - Monday, June 18, 2018 1:32 PM
Try adding this line ...
, AvgSeconds = AVG(IncidentStatusDurationFactvw.TotalTimeMeasure) OVER ()
I do not have...

June 19, 2018 at 10:33 am

#1994480
RE: carving out bussiness hours.

DesNorton - Tuesday, June 12, 2018 12:07 PM
This should give you the the AVG per day as well as the AVG for...

June 18, 2018 at 1:13 pm

#1994352
RE: carving out bussiness hours.

ScottPletcher - Tuesday, June 12, 2018 1:04 PM
DesNorton - Tuesday, June 12, 2018 12:07 PM

June 13, 2018 at 9:35 am

#1993879
RE: carving out bussiness hours.

DesNorton - Tuesday, June 12, 2018 9:01 AM
madmilitia - Tuesday, June 12, 2018 8:37 AM

June 12, 2018 at 10:17 am

#1993721
RE: carving out bussiness hours.

DesNorton - Monday, June 11, 2018 1:21 PM
madmilitia - Monday, June 11, 2018 9:21 AM

June 12, 2018 at 8:37 am

#1993694
RE: carving out bussiness hours.

DesNorton - Thursday, June 7, 2018 12:37 PM
You can create a function to calculate the durations for you.
The function below will...

June 11, 2018 at 9:21 am

#1993561
RE: carving out bussiness hours.

madmilitia - Monday, June 11, 2018 7:57 AM
DesNorton - Thursday, June 7, 2018 12:37 PM

June 11, 2018 at 8:35 am

#1993554
RE: carving out bussiness hours.

DesNorton - Thursday, June 7, 2018 12:37 PM
You can create a function to calculate the durations for you.
The function below will calculate...

June 11, 2018 at 7:57 am

#1993551
RE: carving out bussiness hours.

sgmunson - Thursday, June 7, 2018 10:03 AM
I had to do this once, and it's not all that easy. The first thing...

June 11, 2018 at 7:56 am

#1993549

Viewing 9 posts - 1 through 10 (of 10 total)