thank you for your question. I try to explain my scenario:
I have analyzed the Troughput-Times (or Solution Times) for a company’s activities (Service Desk tickets). I used SOURCE-TARGET to ignore the time of the status closed, because only this time matters for the TPT.So it counts all days (or hours, minutes) from every single day…24 hours, even on the weekend.
But I want to take into account the company’s working times (=service times), so that I can see their actual Troughput time of the activities.
I have deposit the times in the calendar of the data modell but the analyzes do not always take the calendar times into account.
Here is a good example:
I have a Servic Desk Ticket which was opened (status NEW) on Friday at 11:13 AM and was finished (status RESOLVED in this case) on Monday, 04:56 PM.
the analysis now calculates 3,24 days =77,65 hours as TPT
but there is a weekend between the activities, where the company didn’t work because their service times are only from Monday till Friday from 08:00 AM till 6:00 PM.
therefore the actual TPT has to to be round about 15 hours = 0,63 days instead of 3,24 days.
Now I want to include the service-times in my SOURCE-TARGET function to get the right TPT (0,63 days) in the following OLAP table. How is this possible?
I hope my problem becomes apparent - please let me know, if not
Thank you in advance