AGGR() or FIRSTSORTEDVALUE() - Help?

[#1]

Hi

I need some help storing a flag for a oldest date with a minimum value.

This is my data. I need a flag that will give me the OLDEST Date where Hours<MinHours for any Staff member.

The flag value in the bottom data should then be 01/11/2014.

[morganaaron]

Do you need the flag for each Staff member, or just one value overall?

If you need one value you could use: Date(Min(If(Hours<MinHours,Date,)))

[jagan · Accepted solution]

Hi,

Try like this in script

LOAD

Date(Min(Date)) AS OLDEST_Date

FROM DataSource

WHERE Hours < MinHours;

Or in front end

Date(Min(Aggr(If(Hours <  MinHours, Date), Staff, Date, Hours, MinHours)))

Hope this helps you.

Regards,

Jagan.

[#4]

thanx that worked, i just changed the min/date at the front

[#5]

Thanx alot, that script just saved me, so simple but so effective