Working with Chart Facts

Data functions in the Chart section are particularly useful if you want your report to display different types of values. Data functions summarize groups of database records and replace the original values with new summary data.

For example, in the Pivot section, you can show either the total sale, average sale, or the maximum sale of each product by quarter. Each of these dimensions is based on the same underlying values. They differ only in the data function that is applied.

The following table shows the Chart Functions:

Table 43. Chart Data Functions

Data Function	Returns the:
Sum	Sum of all underlying values.
Average	Average of all underlying values.
Count	Number of underlying values.
Count Distinct	Number of distinct values in a column.
Maximum	Highest of underlying values.
Minimum	Lowest of underlying values
Perc of Grand	Sum of underlying values as a percentage of all surface values in the report.
NonNullCount	Number of underlying values; null values are excluded.

To apply a data function:

Select a bar or row of facts (such as Amount).
Select Data Function on the shortcut menu.
A shortcut menu of available data functions is displayed.
Optional: You can also select the item or column and choose Actions, then Data Function, and select the (function).
Select the function.
Each column is recalculated according to the data function applied to the underlying value.