Summary calculations are aggregate functions used for sub-totals and totals. Summary calculations can be set in the Ad Hoc View Panel.
- In the table views, each field can display a single summary calculation. It is automatically applied to all groups in the table. Summaries appear at the bottom of each group as well as the bottom of the view. When a new group is being added it will include a summary for each column.
- In the crosstabs, each measure will display a summarized value. They will determine the values of the Totals at the intersection of each row and column.
- In charts, the type of the chart shall determine whether the measures are summarized.
Default Summary Functions in Calculated Fields
Datatype | Default Summary Calculation | Description |
Numeric | Sum | Display the sum of all values in the set. |
Date | CountAll | Displays the total number of values in the set. |
String | CountAll | Displays the number of values in the set. |
Boolean | CountAll | Displays the number of values in the set. |
Aggregate | AggregateFormula | Uses the aggregate formula as the summary. |
Combined | None | The summary calculation is null. |
Setting a measure’s summary function in any type of view
Function | Meaning | Available for… |
AggregateFormula | Uses the same aggregate formula as the summary | Aggregate |
Average | Displays the average of all values in the set. | Numeric |
CountAll | Displays the number of rows in the set. | Boolean, Date, Numeric, String |
CountDistinct | Displays the number of unique values in the set. | Boolean, Date, Numeric, String |
Custom | Allows you to enter an aggregate calculation for the summary. | Aggregate, Date, Numeric |
Max | Displays the highest value in the set | Date, Numeric |
Median | Displays the median value in the set | Date, Numeric |
Min | Displays the minimum value in the set | Date, Numeric |
Mode | Displays the value that occurs most frequently in the set. | Boolean, Date, Numeric, String |
None | The aggregate function is null | Aggregate, Boolean, Date, Numeric, String |
Range | Displays the difference between the minimum and maximum values of the set | Numeric |
RangeDays | Displays the difference in days between the minimum and maximum values of the set | Date |
RangeHours | Displays the difference in hours between the minimum and the maximum values of the set | DateTime |
RangeMinutes | Displays the difference in minutes between the minimum and the maximum values of the set | DateTime |
RangeMonths | Displays the difference in months between the minimum and the maximum values of the set | Date |
RangeQuarters | Displays the difference in quarters between the minimum and maximum values of the set | Date |
RangeSemis | Displays the difference in semi-annual periods between the minimum and maximum values of the set | Date |
RangeWeeks | Displays the difference in weeks between the minimum and maximum values of the set | Date |
RangeYears | Displays the difference in years between the minimum and maximum values of the set | Date |
Aggregated Formula | Uses the aggregate formula used to define the calculated field as the summary function | Aggregate |
StdDevP | Displays the standard deviation for the population of the set | Numeric |
StdDevS | Displays the standard deviation on a sample for the set | Numeric |
Sum | Displays the grand total for the set | Numeric |
WeightedAverage | Displays the weighted average for the set based on a second numeric field or expression. | Numeric |
Hints
- If you select a summary calculation other than the default one, that calculation is shown in parentheses after the field name in the fields picker.
- Create a custom Summary calculation for a field or measure.
- Remove summaries by setting the summary function to None.
- Only AggregateFormula, Custom or None are supported as summary calculations for aggregate functions.
