Use offset to get next line value on current line

[rpinxt]

Could anybody tell me how I would setup offset (or something better?) to get below calculated column in blue (next time)?

Date	Name	Time	Process	Next time
01-02-24	ALHAJJX	07:32:47	Sumtotal	07:34:54
01-02-24	ALHAJJX	07:34:54	Apply	10:32:36
01-02-24	ALHAJJX	10:32:36	Pauze Uit	10:51:13
01-02-24	ALHAJJX	10:51:13	Pauze Uit	11:24:17
01-02-24	ALHAJJX	11:24:17	Apply	12:30:54
01-02-24	ALHAJJX	12:30:54	Pauze In	13:05:07
01-02-24	ALHAJJX	13:05:07	Pauze Uit	15:01:02
01-02-24	ALHAJJX	15:01:02	Pauze In	15:19:09
01-02-24	ALHAJJX	15:19:09	Pauze Uit	15:36:23
01-02-24	ALHAJJX	15:36:23	Apply	15:57:11
01-02-24	ALHAJJX	15:57:11	Stop	0

[rpinxt]

Again thank you very much @Daniel29195 !
Was able to fit that in my data just fine.

Works like a charm 😄

[Daniel29195 · Accepted solution]

@rpinxt 

use the offset function. 

selectcolumns(

offset( 

1, 

summarize(tbl_name, tbl_name[date], tbl_name[name], tbl_name[time]) , 

orderby( tbl_name[date] , asc , tbl_name[time] , asc) , 

partitionby(tbl_name[name])

),"time", tbl_name[time])

NB:  change the table_bame and column base on your table name and columns name.

let me know if this helps .

If my answer helped sort things out for you, i would appreciate a thumbs up 👍 and mark it as the solution ✅
It makes a difference and might help someone else too. Thanks for spreading the good vibes! 🤠