Products
Admissions & Enrollment
After School Activities
API
Cafeteria & POS
School CRM
Data Analytics & AI
CMS
Donations
Enrollment Management System
Financial Aid Management
Finance & Accounting
Fundraising
Point of Sale
Scheduling
Student Information System
Summer School & Summer Camp
Solutions
K-12 Private and Independent Schools
K-12 Public Schools
Colleges & Universities
Medical Schools
Vocational and Technical Schools
International Schools
Dance and Theater Schools
Youth Programs
Why PCR Educator
Team
Knowledge Base
FAQ
Training and Support
School Portal
Customer Portal
PCR independent school management solution and website
Products
Admissions & Enrollment
After School Activities
API
Cafeteria & POS
School CRM
Data Analytics & AI
CMS
Donations
Enrollment Management System
Financial Aid Management
Finance & Accounting
Fundraising
Point of Sale
Scheduling
Student Information System
Summer School & Summer Camp
Solutions
K-12 Private and Independent Schools
K-12 Public Schools
Colleges & Universities
Medical Schools
Vocational and Technical Schools
International Schools
Dance and Theater Schools
Youth Programs
Why PCR Educator
Team
Knowledge Base
FAQ
Training and Support
School Portal
Customer Portal
Sign In
Demo
School CRM
Blog
DAT Fields - Step 2 - Aggregating
DAT Fields - Step 2 - Aggregating
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.
See also
DAT Fields - Step 2
DAT Display Field
DAT
Linkedin
301-947-7380
sales@pcreducator.com
Schedule Demo
Please, make sure that all required fields (marked with *) are completed.
School Name
*
Relation to School
*
select
Administration - Database Manager
Administration - Head of School
Administration - Registrar
Development - Director of Development
Finance - Business Manager
Finance - CFO
IT - Director of Technology
Other - Parent
Other - Staff
Other - Volunteer
Last Name
*
Your First Name
*
Your Email
*
Your Phone #
*
Household
User
PCR Educator School Information System is an online database engineered for schools and universities to deliver the highest level of flexibility, unique experience, transparent communication and customized design.