Calculate the Average Time of a Contest, Based on the Finishers' Time

To calculate the average time for a specific contest based on finishers' times, a Team Score needs to be created. This will group all participants who have completed the same race.

To filter the participants, you can use the condition: [Finished] AND [Status]=0.

When configuring the Team Score, set the following parameters:

Participants: Minimum 1, Maximum 9999
Women: Minimum 0, Maximum 9999
Max. No. of Teams: "1 and show all participants"

If you want to calculate the average time based on both Contest and Gender, ensure that these fields are included in the Team Aggregation and Grouping Settings.

To calculate the average time, go to the Result section of the Team Score and select the <Finish Result> with the "Average" mode.

Finally, you can access the average time for each contest and gender by referencing the fields [TSX.Time1] or [TSX.DecimalTime1]. This allows you to perform additional calculations requested by the race organizer.

Cookie	LastUser
Description	Stores the customer number from the last login through this browser. Used to prefill the user input in the login area.

Cookie	Cookieconsent
Description	Used to check if the cookie banner was shown to you in the last 35 days. Also stores your specific cookie banner selections.

Cookie	contactform_flag
Description	Checks if the red box with the contact form hint has already been presented in this browser session.checks if the red box with the contactform hint has already been presented in this browser session

Cookie	PHPSESSID
Description	This key is necessary to anonymously identify the current user session by our system. Essential for shopping cart, order process, customer account, etc.This key is necessary to anonoumously identify the current user session by our system. Essential for shopping cart, order process, customer account etc.

Cookie	Vimeo
Description	We use the video platform Vimeo to host videos and embed them into our website. When clicking on the video, Vimeo may set cookies in the browser.

Cookie	analytics_storage
Description	Checks if Google Analytics cookies can be stored to analyze user behavior on the website and understand how visitors interact with our content. By consenting, you help us improve the user experience.

Cookie	ad_storage
Description	Checks if advertising cookies can be stored, which are used for personalized advertising and retargeting.

Cookie	ad_personalization
Description	Controls whether ads are personalized based on the user's behavior and interests to show tailored ads.

Cookie	ad_user_data
Description	Controls whether the user's personal data can be processed for advertising purposes, such as information about age, gender, or interests.

Contact us!