How to display the max values for each distinct item in Tableau?
Column1, Column2, time_stamp
user1, data1, t2
user1, data2, t1
user1, data5, t4
user2, data4, t7
user2, data7, t9
user2, data3, t6
constraint t1 < t2 < t3.... < tn
The output should be
Column1, Column2, time_stamp
user1, data5, t4
user2, data7, t9
I tried the following but I am not sure what it does exactly especially first == 0? what does that tell tableau?
IF FIRST()==0 THEN MAX([time_stamp]) END