Custom Reports: Field Types & Aggregates

Reference

Last published at: April 14th, 2022

Below are definitions of the various field types, and aggregates, available in custom reports.

For instructions showing how to generate custom reports, please refer to Run Custom Reports and Filter, Canned, and Custom Reports.

Field Types

A field that can be one of two values (Yes or No).

A variable character field with an indeterminate length.

A numeric field hold numbers to be calculated.

An integer field uses whole numbers (no fractions or decimals).

The date associated with a piece of data (YYYY-MM-DD).

A collection of variables.

The number of rows in a column.

The distinct number of instances of data in a column.

The sum on an amount.

The average of an amount

The minimum amount in a field

The maximum amount in a field.