14.19: Understanding Domain Aggregation
- Page ID
- 46669
\( \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}}\)\(\newcommand{\AA}{\unicode[.8,0]{x212B}}\)
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
Contributors and Attributions
CC licensed content, Original
- Understanding Domain Aggregation. Authored by: Robert Danielson. Provided by: Lumen Learning. License: CC BY: Attribution