Skip to main content
Business LibreTexts

17.19: Understanding Domain Aggregation

  • Page ID
  • 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.

    CC licensed content, Original
    • Understanding Domain Aggregation. Authored by: Robert Danielson. Provided by: Lumen Learning. License: CC BY: Attribution