Passwort vergessen? Registrieren
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. 

×

Haben Sie eine Frage?

Unser Team berät Sie gern persönlich.

Schreiben Sie uns!

Das Team von RACE RESULT berät Sie gerne zu Ihren individuellen Bedürfnissen, behebt bestehende Probleme und beantwortet Ihre Fragen. Kontaktieren Sie uns jetzt über das Formular.

Wenn Sie eine Support-Frage haben, fügen Sie bitte Ihre Event-ID hinzu!

Ich habe die Datenschutzbestimmungen gelesen.