Peek on first row in subset

[stabben23]

Hi, I want to use first row in a subset of data as comparison.

This is how I have script right now:

if(peek(Key)= Key, DateComparison - peek(StartDateComparison,0),0) as Days

But peek(StartDateComparison,0) will always find First row in table, not first row in subset (Bold Row).

So what I want is that all dates should for all Key should be Compared with StartDateComparison

[MayilVahanan · Accepted solution]

Hi

Try like below

if(peek(Key)= Key, peek(StartDateComparison),StartDateComparison) as StartDateComparison

By using above script, we can able to see  "StartDateComparison" values in all rows. Then, u can simply sub those 2 fields to get the "days".

[stabben23]

Hi @MayilVahanan 

That´s a great input, I will test this in my script.

[stabben23]

Brilliant @MayilVahanan this was exactly what I needed.

Thanks!