Understanding Domain Aggregation

Learning Outcomes

  • Discuss domain aggregation

There are twelve aggregate functions that extract and group data from a larger data set.

  • DSum
  • DAvg
  • DCount
  • DLookup
  • DMin and DMax
  • DFirst and DLast
  • DStDev
  • DStDevP
  • DVar
  • DvarP

These functions all have the same structure:

FunctionName( “ [Field Name] “,” [Dataset Name] “, “[Criteria] “ )

FunctionName is the name of the domain aggregation function being invoked;  Field Name refers to the field containing the data in question; DataSet Name refers to the table in play; and, Criteria limits the inclusion of data per the scope necessary.

These functions can provide everything from a total of the values listed to an average of those values to the standard deviation of the values listed. The Help menu has detailed information about the functions.

PRactice Question

Contribute!

Did you have an idea for improving this content? We’d love your input.

Improve this pageLearn More