Duration Fields: Charts, Duration Calculations, Table Duration Calculations, Durations in Text Calculations and Performance Summary Dashboards, and Performance Standards for Duration Fields
To enable you to track duration times in the system a Duration field has been added to the Form Builder. A number of duration configurations can be used from dd:mm:ss (days:minutes:seconds) to mm:ss.SSS (minutes:seconds.milliseconds). Duration fields can now appear in Performance Summary Dashboards, as part of Excel Reports and they can have Performance Standards created for them. To use these Duration fields effectively in the system they must be formatted correctly. Please familiarise yourself with the information below.
Once you add a Duration Field into an Event Form, you can choose from a number of different duration formats depending on the type of duration you need to track/measure
In the Advanced Properties of the duration field you need to click on the "Format" button and select the format that you want for your field. Make sure you set these exactly as you require. When data is entered into the field in the actual application, users need to write the duration in exactly the same format as you select here. For example, mm:ss would be written as 11:22 and mm:ss.SSS would be written as 11:22.333. The colon and decimal points must be written in the correct place to format the number correctly.
Duration field questions can used in a table, or a single entry field
You can also specify that Duration fields are charted in the Athlete History page (as shown here), by selecting "Chart by Default" on the Advanced Properties for that Duration field
In the Form builder in the Advanced Properties for the duration field you can select to "Chart by default". This works the same for a duration field as any other field and the chart of the field will appear in the athlete history page (as shown here). For more on Chart by Default, see the Event/Form Development Lessons.
To perform ANY Numeric Calculations for a Duration field you MUST use the new Duration Calculation field in the Calculations List. To perform a calculation with a Duration field used in a Table you MUST use the Table Duration Calculation (discussed below).
If you want to add, average, subtract or perform any other numeric calculation using a duration field you will need to use the new Duration Calculation field. It works the same as the other calculation fields where you simply type in the calculation you require into the Calculation section (see the image in the step below). If you want to perform a text calculation using a duration field this is outlined below in this lesson.
A Duration Calculation must be used to calculate Duration fields correctly. For example, if you have a 10m split and a 10-20m split in a sprint form and you need to calculate the 0-20m duration this would be performed with the Duration Calculation field.
This Duration Calculation field example here is summing the 10 and 10-20m split times that are being measure in a ss.SSS format. You can use any of the available calculations such as sum, max, min and the like as you would for any other calculation field. However, you MUST set the format of the Duration Calculation field in the Advanced Properties once you have written out your equation (see the step below).
For a Duration Calculation you MUST set the format on the Advanced Properties. It is best practice to set the Duration Calculation format to the same format as the format of the Duration fields you are using in the calculation (e.g. the 10 and 20m sprint above are captured as ss.SSS).
Use the same format as the Duration fields you are referencing. The equation shown here was set to sum the 10m and the 20m splits which were captured in a ss.SSS duration. Therefore, the format of the Duration Calculation field could also be set as ss.SSS. Other formats can be used, just ensure that you think carefully about what type of duration you are expecting from your calculation and set the format accordingly.
The image here shows the Duration Calculation that references the 10 and 20m ss.SSS fields. The calculation output is displayed in the format set on the Advanced Properties for that field (outlined in the step above).
If you want to perform a calculation on a Duration field that is used in a table you MUST use the Duration Table Calculation field
Add in the Table Duration calculation to the form. In this example we are going to add in two Table Duration Calculations; one to calculate the minimum of the ss.SSS table column, and the other to calculate the sum of the mm:ss.S field
For Each Table Duration Calculation you add, you need to specify the type of calculation of want to perform, and then write in the field names/equation into the Calculation section
Next you MUST select a Format from the Advanced Properties for that Table Duration Calculation field. For example we are selecting ss.SSS as the format to show the results from the equation in the step above.
You must set the format of the Table Duration Calculation field in the Advanced Properties. If you do not select the format that you want the calculation to display in, it will default to "ss". The table calculation will only show in seconds, regardless of whether you are referencing a hh:mm:ss.SSS format for the duration field. Try and ensure the format you select for the Table Duration Calculation is a format that is appropriate for the type of calculation you are performing.
The table calculation will calculate according to the Format you specified in the Advanced Properties for that Field. Two examples shown here are ss.SSS format and a mm:ss.SSS format
On the reports pages and the athlete history pages, the Duration fields, Duration Calculation fields and Table Duration Calculation fields are displayed in the format set in the Form Builder. This example shows the 10m and 20m split times, the duration calculation and another duration field set to mm:ss.SSS
The duration fields appear in the athlete history and reports pages in the format that was specified on the Form Builder. To change the format, it must be changed on the Form Builder. Please keep in mind that duration fields are not handled well by Excel, and if you run an "Excel" report from the Reports page, the formatting may not be set correctly (as shown in the image below).
CSV Issue: If you run an "Excel" download from the Reports Page (shown in the image in the step above), you need to open the file and check that the cell format is that same as the format for the duration type. Sometimes Excel cannot display the duration fields correctly because it may not have a format for it. Always open the download, double check, or reformat the cells' format.
In the image in this step the Excel download from the Reports Page did not produce the correct format for the Duration Calculation Field. To change the formatting:
1: Right mouse click on the cell column
2: Select "Format Cells" (not shown)
3: Select custom
4: Select the correct format type.
Not all formats are supported. The safest reporting method is to use the Excel Reports Module.
You do NOT need to use a special duration calculation for a Text Calculation or a Table Text calculations (shown here). You simply use the existing Text and Table text calculation, but the format of the duration field in the calculation area needs to be written correctly (see the step below)
To use a duration field in a text equation you need to write the equation correctly, and format the duration field IN the text equation.
Previously, duration fields could not be used in text calculations or table text calculations. Now they can be included if you structure your text equation correctly. You must add in duration before the field name and a then format after the field name. For example, when combining the "Split" and "Distance" fields from a table row (as shown in the image in the step below) the Duration field "Split" would be written as duration(Split, "mm:ss.S") . Instead of writing concatenate (Distance, ": ", Split), this would need to be written as concatenate (Distance, ": ", duration(Split, "mm:ss.S") )
You could format the duration field to show in any format that you require. Instead of the split time shown in the image below being shown as a mm:ss.S, you may want it to be shown as a mm:ss.SSS or a hh:mm:ss.SSS. By writing that format after the field name, the data will be displayed in that format.
duration(my duration question, "ss")
duration(my duration question, "ss.S")
duration(my duration question, "ss.SS")
duration(my duration question, "ss.SSS")
duration(my duration question, "mm:ss")
duration(my duration question, "mm:ss.S")
duration(my duration question, "mm:ss.SS")
duration(my duration question, "mm:ss.SSS")
duration(my duration question, "hh:mm:ss")
duration(my duration question, "hh:mm:ss.S")
duration(my duration question, "hh:mm:ss.SS")
duration(my duration question, "hh:mm:ss.SSS")
duration(my duration question, "hh:mm")
This Text Calculation equation is being used to summarise the splits for rowing data. Note that the format of the Rowing Split text calculation is set to mm:ss.S and the actual Split field is set as mm:ss.SS
If you need any additional assistance with the use of Duration fields in text equations, don't hesitate to ask your distributor. Or, you can write a question at the bottom of this lesson.
Performance Standards can now be set for Duration Fields. Add in the coloured performance bands as usual in the Performance Standards Module on the Builder.
Durations can now be used in the Performance Summary Dashboards Module (these are set up in the Performance Summary Dashboards Module on the Builder)
Previously, if a Duration field was used in a Performance Summary Report it would appear in milliseconds. Now the Duration fields can be used in a Performance Summary Report and they show in the correct format. The image here shows that a different Duration fields with a format of ss.SSS and mm:ss.SSS are being pulled through into this Summary Report.