Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
nikhilgarg
Specialist II
Specialist II

issue in set analysis

Hello Everyone,

I have a scenario wherein, user is filling his details every week. `Let say a user has filled details in Week1, Week2 and Week3. Now if anyone selects Week1, Week2, Week3 then latest week data should be visible i.e Week3. IF user selects Week1, Week2 then again latest week data i.e. week2 data should be selected. It can be the case that User 1 has filled data till week3 and user2 has filled data till week2 and if the selection of Weeks are Week1, Week2, Week3 then for User1, Week3 data should be reflected and for User2 Week2 data should be reflected. Can anyone help em how to achieve this? For your reference attached are the files.

1 Reply
rubenmarin

Hi, If last data is fixed (not depending of selections) the better option I think is to set a flag in script to the last record of each user.

Or you can try using FirstsortedValue, like: FirstSortedValue(FieldToShow, -Week)