Access via: Events > Consolidation > (Edit report) > Custom.
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 report column can be one of two types.
- The first non-blank value from up to three different columns, with a default text label.
- A combination of multiple columns.
Click Add New to create a new user-defined column.
The existing custom columns are listed in a table.
- Click one custom column to edit it.
- Click the option to delete a custom column.
The custom columns added here are available on the Columns page to add to the report.
User-Defined Column
Column Name
Column Name is the name of the column as it should appear in all report screens, up to a maximum of 25 characters.Column Definition
Column Definition is the section where you specify which Certain field(s) will make up a user-defined column. Column Definition can also create a column that consolidates several columns into a single column in the report output. Column Definition saves steps of merging cells in a separate application. Column Definition lets you select from the same fields as those 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
Display the first non-blank from is an option that includes 3 drop-down lists and a free-text field.Use Display the first non-blank from when the custom column pulls from one or more Certain fields.
The custom column returns the first non-blank value for each record in the specified 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.
The free-text label examples include:
- '[blank]'
- 'missing'
This example column would return:
- State/Province for records that have a value for State/Province.
- Province/District for records that do not have a value for State/Province.
- City for records that have neither State/Province nor Province/District.
- the text '[blank]' for records that do not have values for State/Province, Province/District, or City.
Combine two or more columns
Combine two or more columns is an option to combine two or more Certain columns into a single report column.Use Combine two or more columns to combine multiple fields into one column in the report output.
Example use case: list registrant's full name in a single column.
This example combines the following fields:
- Prefix
- First Name
- Last Name
- Suffix
The example procedure is:
- Select Prefix in the drop-down list.
- Click Append.
- Select First Name and click Append.
- Select Last Name and click Append.
- Select Suffix.
- Append Suffix.
The field below the Append section will show:
<{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. Once the user-defined column is created, it can be added to the report in the Reports > Columns section.
[//]: # (Screenshots include an article metadata area and auxiliary UI elements that are excluded per instructions.)