Need the average of max date for respective IDs

[jalpashukla]

Hello all, can someone please help me to get the desired result by using chart expression for below table:

IDs	Date	Value
abc	1-jan-2019	3
abc	3-mar-2019	2
abc	14-apr-2019	5
xyz	20-jan-2019	4
xyz	6-apr-2019	2
xyz	28-feb-2019	5

Desired Result:  If I select 'abc', the result should be 5 as 14-apr-2019 is maxdate. The same will happen for 'xyz' as well. But if I don't select anything, the result should be average of (abc-5) and (xyz-2).

Thanks in advance.

@sunny_talwar 

[lironbaram]

Hi 
This expression should work for you :

avg(aggr(FirstSortedValue(Value,-Date),IDs))

[jalpashukla]

Hi,

I tried with this expression but it didn't work for me. 😞  The date is taken as max date in result.

[lironbaram]

Hi 
check out the attached app.