topic Recent Value with MTD in Water Cooler

Recent Value with MTD

kishorj1982 — Fri, 16 Nov 2018 05:45:52 GMT

Hi All,

I want to find the recent value (on Child Id) for each Parent Id within a selected date range (e.g. MTD).

Could you please suggest how to proceed.

I have attached sample the data set for this and I have highlighted the part that we need in output.

I tried with first sorted value but no luck.

Could you please suggest.

Thanks

shiveshsingh — Fri, 16 Nov 2018 06:43:30 GMT

If i see your data, what do you mean by recent value? is it based on C Create Date?

If parent Id is 1, then recent child id will be C_1_5?

kishorj1982 — Fri, 16 Nov 2018 07:28:33 GMT

Yes, requirement is like that.

Thanks

kishorj1982 — Fri, 16 Nov 2018 12:13:10 GMT

@tresB could you please suggest on this.

shiveshsingh — Sat, 17 Nov 2018 12:41:43 GMT

Please use below expression

FirstSortedValue([C Score],-[C Create Date])