CODEWITHSUNDEEP
spotfire
OUMOUSS_ELMEHDI
OUMOUSS_ELMEHDI

Reputation: 519

Spotfire expression - get the minimum of the next indicator per id

for every id, I am trying to get the minimum date of the next indicator next to the previous indicator. it is similar to lead in sql. the wished result is in the column target.

enter image description here

Upvotes: 0

Views: 381

Answers (1)

ksp585
ksp585

Reputation: 1770

@OUMOUSS_ELMEHDI - Below OVER function should give you the desired result.

Min([Timestamp]) OVER (Intersect(Next([Indicator]),[ID]))

Here is the final result table:

enter image description here

Upvotes: 1

Related Questions