max date by field

[Anonymous]

Hello!

I have a problem with the aggregation and max in the set analysis.

I need the max date of each field in a set analysis

Team     Date         

A          1/01/2000         

A          1/02/2000

A          1/03/2000

B          2/01/2000

B          3/02/2000

Team     aggr(max(Date),Team) 

A          1/03/2000

B          3/02/2000

I need something that could give me the date of A and B in set analysis.

I tried with

Date(max(aggr(sum({<Team={'A'}>}Date),Team)))

But it gives me al the Dates from Team A.

Thank you!

[johnw]

Maybe something along these lines?

{<[Date]={"=[Date]=max({1<[Team]={'A'}>} total [Date])"}>}

[sunny_talwar]

How exactly are you using this if you don't mind sharing? May be there is another way to do this?

[Anonymous]

Can you try with this?

{<[Date]={"=aggr(max(Date),Team)"}>}

[maxgro]

concat(TOTAL aggr(Date(max(Date)), Team), ',')

[el_aprendiz111]

Hi,

from script:

[Anonymous]

I tried all the solutions but it doens´t work.

Thanks for your time!

[Miguel_Angel_Baeyens]

Guillermo,

Not sure if this is exactly what you are looking for:

Count items with max date

Max Date, by 1st Dimension, in Pivot

Miguel

[#9]

Hi,

Can you please try using below.

inp:

load * inline [

Team,Date        

A,1/01/2000        

A,1/02/2000

A,1/03/2000

B,2/01/2000

B,3/02/2000

];

output:

load Team, max(Date(Date,'DD/MM/YYYY')) as out

Resident inp

Group By Team

Thanks,
Sreeman