Donwtime calculation

[thiagooliveira]

Hello guys,
I need to calculate the diference between resolve_date and open_date excluding the weekend time and non business time (8 pm to 7 am).

So I only need to count the time between Monday to Friday, at 8 AM to 7 PM.

The period out of this times, I don't need it.

 

I know that exists the PDMDOWNTIME function as we can read on Administration guide, but how this function works?
I try to create this measure on Universe designer, just like this:

 

 

But this function didn't work, how can I do this?

 

Thanks.

[Legacy User]

your question is more opened, witch version of SDM you use... y for all tickets or specific period

 

actually i get this result Monthly for specific group using excel board connected with sql view 

[Michael Mueller]

Hi.

I think your problem is related to your time span : (8 pm to 7 am).

in workshifts Time ranges must be entered with earlier time first.

But their can be more than one time range.

In your case it may look like:

PdmSeconds(PdmDownTime('Rio de Janeiro','Mon - Fri {7:00 am - 12:00 am 12:00 am - 08:00 pm}', open_date, resolve_date))

Hope that helps

 

Regards

..........Michael

[thiagooliveira]

Hi Michael, thanks for your answer and information.

 

I have a doubt: The argument "Rio de Janeiro" is my workshift. It's correct?

Which information must be entered on this argument of pdmdowntime.

 

Thanks for advance.

[Michael Mueller]

HI,

Unfortunately, I have no clue regarding the first argument to PdmDownTime(). As far as my tests are showing, you can specify any string you like. It seems not to have any influence on the downtime calculation.

Regards

..........Michael