Report types

The two types of reports are summarized reports and list reports. List reports display unsummarized or detailed data about individual cases or other data instances. Summarized reports display summary counts, totals, or averages, and you can drill down to supporting information. Summarized reports can also contain charts.

Summarized reports contain two types of columns. At least one column must be a summarized column, which contains data that is summarized by using one of the following built-in functions:

COUNT()
COUNT DISTINCT()
SUM()
AVG()
MIN()
MAX()

Examples of summarized columns include counts of cases, total dollar amounts, average elapsed time between the start and resolution of a work item, the most recent (maximum) date value, and the earliest (minimum) date value.

Columns that do not contain summarized data are group by columns. The group by columns organize the summarized data. For example, you can display summarized values based on numeric properties.

The columns in reports can contain either property values or the values of expressions that contain SQL functions.