Define the columns of an analytic

Every data category collected by your SQL query must have a column assigned to it for it to appear in the table of results in the Global tab. Use the following procedure to add a column.

To define the columns of an analytic:

1. Click the Columns link in the Analytic Definitions section of the side-bar.
2. Use the following table to complete the fields:

3. Field	Description
   Field Index	Type the Field Index number. This number represents where the table whose data you want to display in this column appears in the SQL Definition field. For example, the 4th table in the following graphic is ATT_EXCUSED_IND:
   Long name	Type the column title as you want it to appear in a detailed result.
   Short name	Type the column title as you want it to appear in the table of results.
   User data type	Select the data type you want to display in the column.
   User field length	Type the maximum number of characters for the data in the column.
   User decimal	Type the number of decimal places you want for the display of a numeric value.
   Enabled	Select this checkbox to enable the column.

3. Click Save.