aggr

[#1]

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

[MK_QSL · Accepted solution]

USE STRAIGHT TABLE

Dimension = Name

Expression = FIRSTSORTEDVALUE(Status, -Date)

[#3]

Christian,

Did you try FirstSortedValue ?

FirstSortedValue(Status, -Date)

Fabrice

[tresesco]

PFA

[#5]

Hi Guys

you're all right.

I was just deep inside aggr function. I will therefore remember this one

thank you,

Chris

[#6]

Wellcome Christian,

I think you can also use it with the LOAD statement (and GROUP BY)

Fabrice