Summary functions available for chart data fields
From Office Web Components Charts
Summary functions available for chart data fields
The following table lists the summary functions provided by the AutoCalc
command used to summarize data fields.
| Function | Description |
|---|---|
| Sum | Calculates the sum of the values. |
| Count | Tallies the number of values. Empty values, such as zero-length strings (strings that contain no characters), are included in the count, but null values (values that indicate missing or unknown data) are not included. |
| Min | Returns the smallest value in the field being summarized. |
| Max | Returns the largest value in the field being summarized. |
| Average | Returns the average of the values in the field being summarized. |
| Standard Deviation | Returns the standard deviation of the values in the field being summarized, assuming the values are a sample of a larger population. |
| Standard Deviation Population | Returns the standard deviation of the values in the field being summarized, assuming the values are the entire population. |
| Variance | Returns the variance of the values in the field being summarized, assuming the values are a sample of a larger population. |
| Variance Population | Returns the variance of the values in the field being summarized, assuming the values are the entire population. |
Note The summary functions available for a field depend on the type of data in the field. For example, if a field contains text, you can use only the Count function for that field.