Data functions compute aggregate values, including averages, maximums, counts and other statistics. These functions summarize groupings of data. You can use data functions to aggregate and compute data from the server before it reaches the Results section, or compute different statistics for aggregated Results totals and report items.
The effects of data functions are most dramatic in the Query section. For example, Dollars is an item of sales transaction records for your stores in London and Madrid. You can apply a data function to this item, consolidate the data, and calculate sum totals, average sale values, number counts of individual sales records, or minimum sale values with respect to each city, once the data is retrieved to Results.
To apply a data function, select the item or column, and chooseData Function on the shortcut menu.
Optional: You can also select the item or column and choose Actions , then Data Function, and select the (function).
Table 31. Data Functions
Function | Returns | Availability |
|---|
None | Unaggregated values as stored in the database. This is the default in Query. | Query |
Sum | Sum of underlying values. This is the default in Results and report sections. | All |
Average | Average of underlying values | All |
Non-Null Average | Average of underlying values; null values excluded | Pivot, Chart, Report |
Minimum | Lowest of underlying values | All |
Maximum | Highest of underlying values | All |
Count | Number of underlying values | All |
CountDistinct | Number of distinct values in a column. This function is not supported by all database servers | Query |
Null Count | Number of nulls among underlying values | Pivot, Chart, Report |
Non-Null Count | Number of underlying values; null values excluded | Pivot Chart, Report |
Standard Deviation | Standard deviation of values. This function is not supported by all database servers. | Query |
Variance | Variance of values. This function is available through Oracle servers only. | Query |
Weight | Use for computing weighted items in Pivot reports. | Query |
% of Column | Sum of all underlying values as a percentage of their respective surface column | Pivot |
% of Row | Sum of underlying values as a percentage of their respective surface row | Pivot |
% of Grand | Sum of underlying values as a percentage of all surface values in the report | Pivot, Chart |
% of Category | Group total percentage of the selected value | Report |
Increase | Calculates the increase between the previous two rows or columns | Pivot |
%Increase | Calculates the percentage increase between the previous two rows or columns | Pivot |
Title | Column names | Report |
Null values are empty values for which no data has been specified; null values are not equal to zero.