Overview
- On the User-Defined Column Details page for a report, you can create up to 20 report columns based on fields in your events.
- Each column can be one of two types.
- The first type displays the first non-blank value from up to three different columns, with a default text label.
- The second type is a combination of multiple columns into a single column.
- Click Add New to create a new user-defined column.
- Existing custom columns are listed in a table; click a column to edit it, or use the delete option to remove it.
- The custom columns added here are available on the Columns page to add to the report.
Column Details
Column Name
Column Name – The name of the column as it should appear in all report screens, up to a maximum of 25 characters.
Column Definition
Column Definition – This section is where you specify which Certain field(s) will make up a user-defined column, or create a column that consolidates several columns into a single column in your report output (saving you the steps of merging cells in a separate application). Here you can select from the same fields as those that appear on the Groups page. A custom column is defined as either a database field or free-text, or multiple columns combined into a single column.
Display the first non-blank from
- The first non-blank option uses three drop-down lists, plus a free-text field.
- Select the first non-blank option if the custom column pulls from one or more Certain fields, and will return the first non-blank value for each record in this order.
- If no value exists for the record in the specified field, you can enter a label in the free-text field to display in the report (instead of an empty cell) such as “[blank]” or “missing”.
Example:
- State/Province
- Province/District
- City
- [blank]
That example column would return:
- State/Province for records that have a value for that field,
- Province/District for records that do not have a State/Province,
- City for records that have neither State/Province nor Province/District, or
- the text “[blank]” for records that do not have values for State/Province, Province/District, or City.
Combine two or more columns
- Use this option to combine two or more Certain columns into a single report column.
- For example: list registrant's full name in a single column.
- This can be done by first selecting Prefix in the drop-down list and clicking Append, then First Name and Append, and again for Last Name, and then for Suffix.
- The field below the Append section shows: "<{Prefix}><{First Name}><{Last Name}><{Suffix}>". You can add spaces between fields for proper formatting.
Note
- A user-defined column must have at least one column selected or at least one character entered in the free-text form field.
Next steps
- Once the user-defined column is created it can be added to the report in the Reports > Columns section.
Feedback
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request
Return to top
Comments 0 comments Please sign in to leave a comment.