Hi All,
Here I have 5 Cases (1,2,3,4,5) with multiple timestamps for each of them.
What I want to do is select 'Cleared', 'Not Cleared' or 'match' (these have the column name as 'Vals') based on the MAX time stamp.So, basically each Case should have only 1 value for 'Vals' ie. 'Cleared', 'Not Cleared' or 'match'.
I tried using
{FIXED [Case]: MAX(
IF [Create_Time] = {FIXED [Case]: MAX([Create_Time])} THEN
[Vals]
END
)}
however I am not getting the desired result.
Looking for some advise.
Thanking you
Regards,
Rishi
