Flag setup

[Ironzem]

Hi , I need help in setting a flag - In the following data I have 3 rows , The flag needs to be set per Token based on the Status.

1. All 1st Entry flagged - that I got right by using  If(match(Status,'1st Entry'),1) as FlagEntry,

2. Flag Exit status based on previous status - If Exit comes after a 1st Entry or Transfer = Flag 0 if Exit comes after an Exit or no value =Flag 1

Token	Status	TImestamp	Desired Flag output
444733439845528493	1st Entry	18-09-2022 08:02	1
444733439845528493	Exit	18-09-2022 08:08	0
444733439845528493	Transfer	18-09-2022 08:09
444733439845528493	Exit	18-09-2022 08:10	0
444733439845528493	Exit	18-09-2022 08:19	1
444733439845528493	Exit	18-09-2022 08:34
444733439845528493	1st Entry	17-09-2022 04:42	1
444733439845528493	Exit	17-09-2022 04:55	0
444733439845528493	1st Entry	17-09-2022 09:18	1
444733439845528493	Exit	17-09-2022 09:42	0
444733439845528493	Exit	17-09-2022 09:43	1
17839739266241238273	1st Entry	18-09-2022 04:08	1
17839739266241238273	1st Entry	18-09-2022 04:23	1
17839739266241238273	Exit	18-09-2022 04:25	0
17839739266241238273	Exit	18-09-2022 04:29	1
17839739266241238273	Transfer	18-09-2022 06:22
17839739266241238273	Exit	18-09-2022 06:27	0
17839739266241238273	Exit	18-09-2022 06:46	1
17839739266241238273	1st Entry	18-09-2022 08:14	1
17839739266241238273	Exit	18-09-2022 08:14	0
17839739266241238273	Transfer	18-09-2022 08:15
17839739266241238273	Exit	18-09-2022 08:21	0
17839739266241238273	Exit	18-09-2022 08:52	1
17839739266241238273	Transfer	18-09-2022 08:52
17839739266241238273	Transfer	18-09-2022 08:58
17839739266241238273	Exit	18-09-2022 08:59	0
17839739266241238273	Transfer	18-09-2022 09:00
17839739266241238273	Exit	18-09-2022 09:06	0
17839739266241238273	Exit	18-09-2022 09:14	1

[lockematthewp · Accepted solution]

If(Status = '1st Entry', 1, if(peek(Status) = 'Exit'), 1, 0))

[Ironzem]

Thank you