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.
Although data functions are relatively standard, there may be additional data functions available to you in the Query section, depending on your RDBMS. |
To apply a data function, select the item or column, and choose Data Function on the Query, Pivot, Chart, Results or Table menu.
You can also select the item or column, activate the shortcut menu, point to Data Function, and select (function).
In report sections, you can apply data functions only if you select a single fact column. You can also change the way data functions are computed. |
The following table lists the available data functions.