99.987% uptime·0 security breaches·35+ years in education·Built and supported in the U.S.
Posted November 09, 2018
DAT Fields - Step 2 - Aggregating
Aggregation is a part of the DAT Fields - Step 2 process and it allows you to use of one of the aggregate functions as opposed to using the field directly. You can specify an aggregate function for any numeric DAT Display Field.

Example:  You have selected fields for customer and invoice total.  You can use the sum aggregate to get the invoice totals for customers.  Suppose you now change that to have customer, invoice date, and invoice total.  Now, when you use the sum aggregate on the invoice total, you will get the daily invoice total for customers.  Each additional field you have in your result will further determine how the Aggregate is calculated.

    - Count will give a count of all the values.

    - Distinct Count will give a count of unique values.

    - Average will give the arithmetic mean - defined as Sum / Count

    - Max will find the maximum value.

    - Min will find the minimum value.

    - Sum will add up all the values.
Update

Streamlined Selector and Widget Configuration

1 min read · Updated April 26, 2026

Was this article helpful?

Your feedback goes to the team that maintains this article.

Thanks. We use this to improve the article.

Still have questions?

Live chat is staffed weekdays 8 am to 7 pm ET. Tickets get a response within one business day.

Open a ticket

New to PCR Educator?

If you landed here from a search and want to see what PCR can do, the demo is the fastest way in. Thirty minutes, no commitment.

Book a demo