Calculate new Column using date

I'm starting with spotfire, I have a dataconector which contains the following columns, I would like to create a new column which indicates if an object found in an 'LSTOR' device is found at a later date in another device other than 'LSTOR'.

Thanks for your help

I could do it for your sample dataset defining first a column LSTOR_TS as:

case  when [Equipement]='LSTOR' then Min([TimeStamp]) over ([Object]) end

then defining the target column as:

SN(case  when Max([LSTOR_TS]) over ([Object])<Max([TimeStamp]) over ([Object]) then True else False end,False)

the SN(..) being there to cater when there is no LSTOR value.

This solution would return False if there were LSTOR and another equipment on the same day.