Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
How can I found value of one field, corresponded to max value of another field. In a chart
Example attached. Thank you
Hi Yuriy, set analysis won't work if you want to calculate it row by row, you can use an expression like:
Aggr(If(Date=Max(TOTAL <ID> Date), Sum(Value)), ID, Date)
Try:
sum({$<Date={$(= max (ID))}>}Value)
Hi Yuriy, set analysis won't work if you want to calculate it row by row, you can use an expression like:
Aggr(If(Date=Max(TOTAL <ID> Date), Sum(Value)), ID, Date)
I guess you meant
sum({$<Date={$(= max (Date))}>}Value)
Doesn't work. It tries to find max date from all model in every ID. But I need to calculate max date for every specific ID
Hi Ruben. It works! Thanks a lot