Password dimenticata? Iscriviti
Change in Ranks

This task is designed to be used for live leaderboards to help show the change in ranks for participants. 

The Output is sorted and grouped similar to a Live output list.

First sorted by {LastSplit}.OrderPos from largest to smallest, grouped by {LastSplit}.Label to show the last split they were seen at and finally sorted by {LastSplit}.DecimalI.

For the change in ranks there are 2 fields we need to consider, their current rank and the previous rank. 

For the current rank we use {LastSplit}.Overall
Previous Split data can be accessed using the .Prev Dot Logic. Here we use {LastSplit}.Prev.OverallI
The same could be applied using the Gender or AgeGroup ranks.

For the calculation we subtract the current rank from the previous rank

[{LastSplit}.Prev.Overall]-[{LastSplit}.Overall]

In this way if a participant's rank improves then the value is shown as positive, and if they lose places it is negative. You may prefer to show these the opposite way round, to do this you could reverse the rank fields in the calculation. 

The final step is to format this, there are 2 considerations to make, how to differentiate between positive and negative changes and what to show if their rank does not change (change = 0).

For the display of this change we include the calculation in an IF statement

If([{LastSplit}.Prev.Overall]-[{LastSplit}.Overall]=0;"-";format([{LastSplit}.Prev.Overall]-[{LastSplit}.Overall];"+s"))

First, if the change is equal to 0 then we display "-" in place of the value, which is cleaner in Outputs. Secondly we use format() to format the number as "+s" this will now show a plus or minus sign for all values whether positive or negative. 

The final part is using Dynamic Formatting to show positive changes in green, negative changes in red and no change to remain black.

Since we have 3 options we use a switch()

Switch([{LastSplit}.Prev.Overall]-[{LastSplit}.Overall]>0;"C(0,255,0)";[{LastSplit}.Prev.Overall]-[{LastSplit}.Overall]<0;"C(255,0,0)")

This colours values larger than 0 in green, values smaller than 0 in red and for values which are equal to 0 they will fall back to the default colour which is black. 

×

Ha qualche domanda?

Il nostro team sarà lieto di consigliarla personalmente.

Contattaci!

Il team di RACE RESULT sarà lieto di valutare le vostre esigenze individuali, risolvere eventuali problemi e rispondere a qualsiasi domanda. Non esitate a contattarci tramite il modulo disponibile ora.

Se hai una richiesta di supporto, aggiungi il tuo ID evento!

Ho letto i termini sulla privacy dei dati.