Lapse Time Between Records by User Inner Join Issue
I am working with dektop and I am trying to develop a chart that shows the time lapses between activities for individual employees. Example dataset would be below, in reality the data will come in via a spreadsheet and will not be ordered.
This almost works but I have got something wrong with my Inner Join, it is mixing up the employees together. I just want the join for the lead and lag for individuals discreetly see screen shot. I have applied a filter to the Results table and just selected the users PETE02 but it is showing ActionUser 199345. I am also getting a sync error even though the application runs, is that todo with columns alias?