| Note |
|---|
Since summary functions reduce data to a single line (based on the field that has been summarized) and groupings pull like/matching data together according to a specific field/value, the most meaningful data comes from utilizing the two in tandem. It doesn't matter which you apply first, but that you do both (unless every field has a summary function applied to it, in which case a grouping would not be necessary). |
Summary functions perform simple calculations on an entire column in order to produce a new piece of data. By applying summary functions to specific fields, new data points can be quickly created, including average, minimum, maximum, and so on.
...