Problem in set analysis to find latest value

sagarjagga — Fri, 16 Nov 2018 11:21:54 GMT

Hi All,

I need to show latest rating in selected date range for given users.Below is the sample data.

I have field name date which contains all the dates in a calendar.

so if a select a date as 10/16/2018 , it should return me the latest rating of users. the result should be like

and if a select a date as 11/07/2018 . the table should return

as for A and c the latest rating is 2 and 3 respectively.

Regards,

Sagar

Re: Problem in set analysis to find latest value

Gysbert_Wassenaar — Fri, 16 Nov 2018 11:45:59 GMT

Perhaps like this: max({<[update date]= {"<=$(=max([update date]))"}>}Rating)

Or perhaps a better solution is FirstSortedValue({<[update date]= {"<=$(=max([update date]))"}>}Rating, -[update date])