Using nthmax and nthmin with historical calculations to calculate the 2nd, 3rd or 4th best results

 

You can set up historical calculations to pull though the nth maximum or minimum value for an athlete

You can set up historical calculations to pull though the nth maximum or minimum value for an athlete

 

Now you can pull through the second and third highest scores for the athlete using nthmax

Now you can pull through the second and third highest scores for the athlete using nthmax

Nthmax works for Historical Calculation Fields

For fields that are set where higher values are best you can pull through the best score, the second best score etc.

-To calculate the second best score: nthmax(2, Historical Field)

-To calculate the third best score: nthmax(3, Historical Field)

Alternatively, for fields where lower values are best you could pull through the worst, second worst scores etc.

N.B. The nth max is ONLY designed to work for up to 20 values (e.g. nthmax(20, Historical Squat 1 RM)

Nthmin can be used to pull through the second and third highest scores for values where lower is better

Nthmin can be used to pull through the second and third highest scores for values where lower is better

Nthmin works for Historical Calculation Fields

For fields that are set where lower values are best you can pull through the best score, the second best score etc.

-To calculate the second best score: nthmin(2, Historical Field)

-To calculate the third best score: nthmin(3, Historical Field)

Alternatively, for fields where higher values are best you could pull through the worst, second worst scores etc.

N.B. The nth min is ONLY designed to work for up to 20 values (e.g. nthmin(20, Historical 20m Sprint Time)

On the application the nthmax and min calculations go back through the historical data to pull out the appropriate scores.

You can see here that the nthmax 2 and nthmax 3 only calculate when there are two or three pieces of data in the system, respectively. If you had an nth max of 20, then 20 pieces of data would need to be entered before it could calculate.

The image here shows that the max Squat as of the 1st May 2013 is 95, the 2nd Max is 94 and the third max is 93.

The image here shows that the min 20m Sprint as of the 1st May 2013 is 3.0, the 2nd Max is 3.30 and the third max is 3.31

An error may be appearing on the builder site for the Event Form when you add these historical calculations. However, the fields are being calculated correctly.

 

0 Comments

Add your comment

E-Mail me when someone replies to this comment