FirstSortedValue with Aggr

[ilanbaruch]

hi all,

i have an aggr expresion which retrives Status dates,

=DATE(aggr(status_date,order),'DD/MM/YYYY')

i want to retrive the min date value

tried it with:

FirstSortedValue(status_date, aggr(status_date,order))

any ideas?

advanced thanks

[YoussefBelloum]

Hi,

would you be able to share with us more details on this ?

what you have so far and what is the expected output ?

[ilanbaruch]

order	date	quantity	Status
1-9660100	22/04/2018	1	75
1-9660100	23/04/2018	1	75
1-9660100	24/04/2018	1	75
1-9660100	25/04/2018	1	75

i need to retrive only one row whith the min/max date

[Miguel_Angel_Baeyens]

Did you try?

FirstSortedValue(order, -date)

With the "-" before the date to get the highest value (most recent date) or without it for the opposite (oldest date)

[tresesco]

Straight table:

Dimension: Order

Exp1: Date(Max(Date))

Exp2: FirstSortedValue(Quantity, -Date)

Exp3: FirstSortedValue(Status, -Date)

For Min you could adjust.

[sunny_talwar]

If the Quantity and  Status are always the same across all dates, then you can also use Only(Quantity) and Only(Status), but this might be only true in the sample, but just to throw out an option