Time between Closed and Start in Sequence of events.

[former_member593593]

My specific issue is in regards to time between different events. My Example of data:

Date | User |Ticket |Seq | Start | Closed Hour

01/01/2018| AB1234| 1234216| Seq 1| 08:00| 12:01

01/01/2018| AB1234|1328903| Seq 2|12:11|13:00

01/01/2018| AB1234|1762349| Seq 3| 13:03|14:05

01/01/2018| AB1234|1674365| Seq 4| 14:05|16:00

I need to get the time difference between the CLOSED HOUR of each Ticket and the Start Hour of next ticket in Sequence. I have tried different ways but no success. Any expert help would be appreciated.

[denis_konovalov]

I have fixed your tags. Since you haven't specified product(s) you are using and assuming you are using reporting in SAP Business Intelligence platform, I set tags to the most likely areas.

Next time, please be more descriptive and select tags more carefuly.

[wobi]

I have it in BO 4.2.4

- Wobi

Syntax

int TimeBetween(first_date;last_date;period)			

[former_member593593]

I only have 4.1 sir. I appreciate the response and hope there is an answer for 4.1.

[former_member593593]

Any expert out there able to tackle this?

[former_member593593]

In SQl this case statement was able to work: ,case when seq = 1 then null else lag(Closed Hour) over (order by [Date], user, seq) end as [Time_Between]

I do not know how to recreate this in Business Objects 4.

[former_member593593]

I am in Business Objects 4. I do not have a TimeBetween function available nor a MinutePeriod.

[ayman_salem]

use following formula:

=TimeBetween(Previous([Closed Hour];([User])); [Start]; MinutePeriod)

This calculates the time between tickets in "min" for each "user".

..

it is better to use a combined "date and time" in the formula (the "start" of the ticket is on another day of "closing" the previous ticket)