Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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!
Maybe something along these lines?
{<[Date]={"=[Date]=max({1<[Team]={'A'}>} total [Date])"}>}
How exactly are you using this if you don't mind sharing? May be there is another way to do this?
Can you try with this?
{<[Date]={"=aggr(max(Date),Team)"}>}
concat(TOTAL aggr(Date(max(Date)), Team), ',')
Hi,
from script:
I tried all the solutions but it doens´t work.
Thanks for your time!
Guillermo,
Not sure if this is exactly what you are looking for:
Max Date, by 1st Dimension, in Pivot
Miguel
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