Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
May be using set analysis
FirstSortedValue({<DATE = {[>$(=Date(MakeDate(2018, 12, 31), 'DateFieldFormatHere'))]}>} PRICE1+PRICE2, -DATE)
May be using set analysis
FirstSortedValue({<DATE = {[>$(=Date(MakeDate(2018, 12, 31), 'DateFieldFormatHere'))]}>} PRICE1+PRICE2, -DATE)
THANK YOU SUNNY
Your always welcome Souad 🙂