Adding columns

To customize a report to better suit your business needs, you can add columns by using the Report Editor. When you add columns, you can specify how the data is displayed and formatted.

1. In the Report Editor, click +Column in the Columns section.
2. Browse or search to select the field that you want to add as a column. You can use the Calculation Builder to help you define an SQL expression.
3. Click the name of the column that you added and use the following menu options to specify how the data is displayed and formatted:
   • Show data as — Specifies how data is displayed. The available options depend on the field and include:
     • List — Displays data in a list.
     • Group — Groups data by values in this column.
     • Count — Displays a count of the number of rows with a non-null value in this column.
     • Count distinct — Displays a count of the number of unique values in this column.
     • Sum — Adds all instances of this field.
     • Max — Displays the highest value.
     • Min — Displays the lowest value.
     • Average — Displays the average of this field.
   • Format column — Specifies the name that displays in the column header.
   • Move left — Moves the column one place to the left.
   • Move right — Moves the column one place to the right.
   • Remove column — Removes the column from the report.
4. To sort the values in columns by ascending or descending order, click Sort columns in the Columns menu, and specify sort conditions.
5. Click Done editing to save your changes, or click Discard to exit the Report Editor without applying any changes.