FirstSortedValue()

[souadouert]

Hello
I have a question about the arguments of the FirstSortedValue function in the graphs , my expression

Count(aggr(Count(DISTINCT {<ID = {"=Index(Concat(DISTINCT {<YEAR= {$(=(YEAR))}>} '|' & REACT& '|'), '|1|')
and FirstSortedValue(PRICE1+PRICE2, -DATE) > 0"}>} ID),ID))

the expression is working correctly but I have to add a condition on the date

FirstSortedValue(PRICE1+PRICE2, -DATE>20181231) > 0"}>} ID)

Count(aggr(Count(DISTINCT {<ID = {"=Index(Concat(DISTINCT {<YEAR= {$(=(YEAR))}>} '|' & REACT& '|'), '|1|')
and FirstSortedValue(PRICE1+PRICE2, -DATE>20181231)> 0"}>} ID),ID))

[sunny_talwar · Accepted solution]

May be using set analysis

FirstSortedValue({<DATE = {[>$(=Date(MakeDate(2018, 12, 31), 'DateFieldFormatHere'))]}>} PRICE1+PRICE2, -DATE)

[souadouert]

THANK YOU SUNNY

[sunny_talwar]

Your always welcome Souad 🙂