A Dashboard enables you to determine the nature of the values represented in a Table Fact column in the Report section. Data functions retrieve underlying values and recalculate the value according to the type of data function that you specify. For example, the totals for a column are sums (the default data function) of the values in a column. You can use other data functions to change the totals to averages instead of sum.
Interactive Reporting provides a variety of prebuilt data functions that can be accessed from the Expression Line. You can also define your own data functions using JavaScript.
To apply a prebuilt data function in the Report section:
Select a table fact.
Select Report, then Data Function, and then Function.
The totals in the column are recomputed to reflect the selected data function.
The following table lists the prebuilt data functions available in the Report section.
Table 105. Prebuilt Data Functions in Report section
Data Function | Description |
|---|
Column Name | Returns the table column name. |
Sum | Returns sum of underlying values. This is the default data function. |
Average | Returns average of underlying values. |
Count | Returns number of underlying values. |
Maximum | Returns highest of underlying values. |
Minimum | Returns lowest of underlying values. |
% of Category | Returns group total percentage of the value. |
Null Count | Returns number of nulls among underlying values. |
Non-Null Count | Returns number of underlying values; null values are excluded. |
Non-Null Average | Returns average of underlying values; null values are excluded. |
To set a data function to the default sum total:
Select a column that has been computed with a data function.
A pull-down list of valid data functions displayed.
Click 
on the Standard toolbar.