Formatting the view
You can control how the view is displayed using the following options in the Column Configuration:
- Display Name – The column name is the default field name. You can edit the Display Name to change how it will be listed in the view.
- Visible – Use the Visible check box to show or hide columns in the view.
- Filter – Enter the filter criteria you want to apply to the column data. For additional information about entering filter criteria, refer to Defining Filter Criteria. You can use Clear Filter to clear all filter criteria from the view definition.
- Sort – Select the sort order for the column:
- Asc – Sort the column in ascending order.
- Desc – Sort the column in descending order.
- Null – Apply no sort to the column.
You can use Clear Sort to clear all sorting from the view definition.
- Delete – Click Delete
to remove a column from the view definition.
- Aggregate – By default, all values are displayed in individual rows in the view. You can aggregate records, so that only unique occurrences are shown. Depending on the data type of the column, the Aggregation field will offer options for the data type:
Aggregation
Description
Group By
When this option is selected, one row is displayed for each unique value of this field. Group By is the only option available for text fields.
Sum
When this option is selected, the total for the field values for grouped records is displayed. The rows displayed are based on the group defined by Group By columns.
Average
When this option is selected, the average for the field values for grouped records is displayed. The rows displayed are based on the group defined by Group By columns.
Minimum
When this option is selected, the minimum of the field values for grouped records is displayed. The rows displayed are based on the group defined by Group By columns.
Maximum
When this option is selected, the maximum of the field values for grouped records is displayed. The rows displayed are based on the group defined by Group By columns.
Count
When this option is selected, the count of the records is displayed as determined by the Group By columns. The rows displayed are based on the group defined by Group By columns.
Count Distinct
When this option is selected, the count of unique values is displayed as determined by the Group By columns. The rows displayed are based on the group defined by Group By columns.
Standard Deviation
When this option is selected, the standard deviation of the field values for grouped records is displayed. The rows displayed are based on the group defined by Group By columns.
Variance
When this option is selected, the variance of the field values for grouped records is displayed. The rows displayed are based on the group defined by Group By columns.
Last modified: Wednesday May 15, 2024