User-Defined Column Details (Event Reports)

(Event) > Reports/Analyze > (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 event.

Each one can be one of two types:

• The first non-blank value from up to three different columns, with a default text label,
  or

• 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 to edit it, or click  to delete it.

The custom columns added here are available on the Columns page to add to the report.

User-Defined Column

• Column Name – The name of the column as it should appear in all report screens. Maximum length = 25 characters.

• 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 for the report. A custom column is defined as a database field or free-text, or multiple columns combined into a single column.

• Display the first non-blank from (3 drop-down lists, plus a free-text field) – Select this option if the custom column is pulling from one or more Certain fields, and must return the first non-blank value for each record in this order. If no value exists for the record in the field specified 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
    or: Province/District
    or: City
    or: [blank]
  
  This 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. You could do this 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 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 page.