Announcements
cancel
Showing results for
Did you mean:
Creator III

## Get Max Date with Associated Value

Hello,

I have the following table, where Date format = DD/MM/YYYY:

DateCurve ACurve B
1/8/201726,6226,97
2/8/201726,7826,83
3/8/201726,6326,80
4/8/201726,7326,86
7/8/201726,3528,05
8/8/201726,2726,75
9/8/201726,8028,05
10/8/201727,1026,96
11/8/201727,3527,47
14/8/201727,5227,69
15/8/201728,3425,69

What I need is to create a Textbox with Max value from Curve A (28,34) and Max value from Curve B (28,05).

Then, also create another Textbox with the associated Date for each Max value. Curve A = 15/8/2017 and Curve B = 9/08/2017 and 7/8/2017.

Do you know how to do that?

Thank you!!!

3 Replies
MVP

May be this

Concat(DISTINCT Aggr(If([Curve B] = Max(TOTAL [Curve B]), Date), Date), ', ')

and

Concat(DISTINCT Aggr(If([Curve A] = Max(TOTAL [Curve A]), Date), Date), ', ')

MVP

These functions should work:

max([Curve A]) max([Curve B]) concat({<[Date]={'=[Curve A]=max(total [Curve A])'}>} Date, ', ') concat({<[Date]={'=[Curve B]=max(total [Curve B])'}>} Date, ', ')
28.3428.0515/8/20177/8/2017, 9/8/2017
Specialist III

You can also achieve with :

=concat(date(if(aggr(rank(Curve_A,0,1)=1,Date),Date)),' , ')

and

=concat(date(if(aggr(rank(Curve_B,0,1)=1,Date),Date)),' , ')

Community Browser