This space is for everyone to ask questions related to the Community Platform. It's a space for us to get to know each other and have some fun! Come in and gather around the Water Cooler!
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.
Please use below expression
FirstSortedValue([C Score],-[C Create Date])
View solution in original post
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?
Yes, requirement is like that.
@tresesco could you please suggest on this.