RaceDay Scoring allows you to filter the data that is scored in a Report Section within a Report. What this means is that you can, for instance, have a Report Section within a Report that ranks the top ten finishers who have "Philadelphia" listed as their "City".
To get started select Actions > Edit on an existing Report in your Report List, or build a new Report as described here.
Either way, you'll end up in the Report Builder.
Next, expand the Filters & Sorts section for the Report Section you would like to add a filter to:
Now click the Add Participant Scoring Filter button:
You have the option here to use Scoring or Display Filters. Scoring Filters are most typically used, and will make it so that Place field is adjusted to be accurate for each participant's placement within the filtered Report Section. If you use a Display filter, the Participant's original placement is retained, and we add a "Section Place" column automatically which will keep track of their placement within this filtered Report Section.
Now that you have a new row, you need to select what Field you will be filtering on - like "City".
In my example, I want to include only those who are listed with a city of "Philadelphia", so I enter that into the Value field:
Now when you click Save Report you'll see that this Report Section is filtered to only include those participants whose City is equal to "Philadelphia".
You can use other Fields and Operations to generate any number of custom Report Sections.
Operation Definitions
- "==" - Select all participants that have fields that match this value exactly.
- "!=" - Select all participants that have fields that do NOT match this value exactly.
- "<" - Select all participants that have fields with a value that is less than the one provided. Generally used for numerical values.
- "<=" - Select all participants that have fields with a value that is less than or equal to the one provided. Generally used for numerical values.
- ">" - Select all participants that have fields with a value that is greater than the one provided. Generally used for numerical values.
- ">=" - Select all participants that have fields with a value that is greater than or equal to the one provided. Generally used for numerical values.
- Is Null - Select all participants that do not have a value for this field.
- Is Not Null - Select all participants that have a value for this field.
- Starts With - Select all participants whose field values that start with this value.
- Contains - Select all participants whose field values contain this value.
- In - Select all participants that have a field value that matches at least one of these. Works like an OR filter.