Applying an Aggregate to a Report

Aggregates can be applied to Tasks Listings. In conjunction with control breaks data can be formatted to a view which is easy to read and understand.

There are 7 types of Aggregate which you can apply to a report:

  1. Sum
  2. Average
  3. Count
  4. Count Distinct
  5. Minimum
  6. Maximum
  7. Median

In the example shown below and aggregate has been applied to count the number of Late tasks in each of the Runbooks in the Event.

Apply will add the count to the bottom of each control break.