# 14.19: Understanding Domain Aggregation

$$\newcommand{\vecs}[1]{\overset { \scriptstyle \rightharpoonup} {\mathbf{#1}} }$$ $$\newcommand{\vecd}[1]{\overset{-\!-\!\rightharpoonup}{\vphantom{a}\smash {#1}}}$$$$\newcommand{\id}{\mathrm{id}}$$ $$\newcommand{\Span}{\mathrm{span}}$$ $$\newcommand{\kernel}{\mathrm{null}\,}$$ $$\newcommand{\range}{\mathrm{range}\,}$$ $$\newcommand{\RealPart}{\mathrm{Re}}$$ $$\newcommand{\ImaginaryPart}{\mathrm{Im}}$$ $$\newcommand{\Argument}{\mathrm{Arg}}$$ $$\newcommand{\norm}[1]{\| #1 \|}$$ $$\newcommand{\inner}[2]{\langle #1, #2 \rangle}$$ $$\newcommand{\Span}{\mathrm{span}}$$ $$\newcommand{\id}{\mathrm{id}}$$ $$\newcommand{\Span}{\mathrm{span}}$$ $$\newcommand{\kernel}{\mathrm{null}\,}$$ $$\newcommand{\range}{\mathrm{range}\,}$$ $$\newcommand{\RealPart}{\mathrm{Re}}$$ $$\newcommand{\ImaginaryPart}{\mathrm{Im}}$$ $$\newcommand{\Argument}{\mathrm{Arg}}$$ $$\newcommand{\norm}[1]{\| #1 \|}$$ $$\newcommand{\inner}[2]{\langle #1, #2 \rangle}$$ $$\newcommand{\Span}{\mathrm{span}}$$

## 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

https://assessments.lumenlearning.co...essments/18793

## Contributors and Attributions

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

14.19: Understanding Domain Aggregation is shared under a CC BY license and was authored, remixed, and/or curated by LibreTexts.