DCountDistinct() : : Knowledge Base

RACE RESULT Knowledge Base > RACE RESULT 14 > Fields, Expressions and Functions > Functions > Inter-Record Functions

DCountDistinct()

DCountDistinct() determines how many distinct values of a field exist (first parameter), for those participants fulfilling a filter (second parameter):

DCountDistinct("[Club]"; "[Finished]") - returns the number of different clubs with finishers

Why the double quotes around the field names? Because the parameter is the name of the field that the function shall analyze!

Note that the aggregation functions are not very fast and should be used rarely.

Do you have a question?

Our team is happy to advise you personally.

╳

Event ID* Order ID* First Name* Last Name* Email* Subject*

If you have a support question, please add your event ID!

Message*

I have read the data privacy terms.

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!