This guide will go over how to set up the necessary fields used to score a prediction run, where you will rank participants based on how close they were to their estimated finish time. It's recommended to have a general understanding of Computed Fields when setting this up which you can learn from this guide: Introduction to Computed Fields : RaceDay Scoring (rdscoring.com)
1). Create a Custom Field that subtracts the custom question time from the "Entire Race Clock Time (ms)" (or chip time if you're using that). It is important that you select the millisecond field and not the standard time field.
2). Create a Custom Field that is the absolute value version of the field you created above.
3). Create a Custom Field that is the transformation of the absolute value in milliseconds to a standard time field.
4). Add the transformed absolute value field onto your report, along with the predicted time
5). Use the millisecond version of the absolute value field as a sort override in your report if you want to sort by the time offset.
1). Create the "Predicted Time Offset (ms)" field.
1a). Go to the "Scoring" settings from the Dashboard:
1b). Open up the "Computed Fields" panel and click "Add/Edit Custom Fields"
1c). Click "Add a Field".
1d). Create the offset in milliseconds field with these settings. You can change the name and label if you like. We autmoatically convert the timestamp from the question responses to milliseconds for this, so you just need to select the millisecond version of the Entire Race time you want to use.
- Fill out the Computed Field Name (I used "predicted_time_offset_ms")
- Fill out the Field Label (I used "Predicted Time Offset (ms)")
- Select "Operation" from the "Type of Value", then select "Subtraction"
- In the "Value 1" box select "Existing Value" then "Entire Race Clock Time (ms)" or chip time version.
- In the "Value 2" box select your RSU question.
- Save
2). Create a Custom Field that is the absolute value version of the field you created above.
- Fill out the Computed Field Name (I used "abs_predicted_time_offset_ms")
- Fill out the Field Label (I used "Absolute Value Predicted Time Offset (ms)")
- Select "Existing Field" from the "Type of Value" dropdown
- Select your predicted time offset in milliseconds field we created in step 1.
- Type in "abs" into the "Transformations" field to convert this to an absolute value version of the time offset in milliseconds.
This will create a time field that you can sort a report on. Sort fields must be in ms.
3). Create a Custom Field that is the transformation of the absolute value in milliseconds to a standard time field.
- Fill out the Computed Field Name (I used "abs_predicted_time_offset")
- Fill out the Field Label (I used "Absolute Value Predicted Time Offset")
- Select "Existing Field" from the "Type of Value" dropdown
- Select your predicted time offset in milliseconds field we created in step 1.
- Type in "ms2time" into the "Transformations" field to convert this to a humanly readable time format.
This will give you the field that you would want to show in reports.
4). Add the transformed absolute value field onto your report, along with the predicted time.
- Build a Report from the Reports view
- Type in the name of the report, select your Event in the "Events to Include" area, then add an Overall Section.
- From the new Report Section, select "Add Columns" and search for your "Predicted" fields.- Add "Please Select your Predicted Time" and "Absolute Value Predicted Time Offset"
- If you like, you can rearrange the fields using the "Edit Columns" area.
5). Use the millisecond version of the absolute value field as a sort override in your report if you want to sort by the time offset.
- Open up the "Filters & Sorts" panel
- Select the "Absolute Value Predicted Time Offset (ms)"
- Save the report.
I added a couple of fake times and bibs to show how this works. The first person ran slower than their predicted, and the second ran faster, but the first one was closer to their prediction so is ranked ahead.
In addition, if you want to publish any of these custom fields to results at RSU, you have to remember to enable them when setting up your auto-save by going into the advanced settings and selecting "Arbitrary Text" for those fields:
