Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi everybody
I've a little aggr issue to solve
Some people have 2 status. When there are different i can't display the last one.
Ex :
Name Date Status
A 2/11/13 open
A 2/12/13 stand by
B 5/11/13 open
B 2/12/13 open
What i get is
Name Status
A -
B open
and I'd like to get Status Stand by for A
I tried to aggregate on max(date) but it didn't work
Thank you for your help
Chris
USE STRAIGHT TABLE
Dimension = Name
Expression = FIRSTSORTEDVALUE(Status, -Date)
USE STRAIGHT TABLE
Dimension = Name
Expression = FIRSTSORTEDVALUE(Status, -Date)
Christian,
Did you try FirstSortedValue ?
FirstSortedValue(Status, -Date)
Fabrice
PFA
Hi Guys
you're all right.
I was just deep inside aggr function. I will therefore remember this one
thank you,
Chris
Wellcome Christian,
I think you can also use it with the LOAD statement (and GROUP BY)
Fabrice