Brio Software
Technical Publications
Home Previous Next Index Glossary
Data Analysis and Reporting with Intelligence Clients

Applying Data Functions

A Data Function 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.

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:

  1. Select a table fact.
  2. Choose Report then Data Function then Function.
  3. 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.

Report Section Data Functions 

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:

  1. Select a column that has been computed with a data function.
  2. A pull-down list of valid data functions appears.

  3. Click the summation icon on the Standard toolbar.

Home  |  Previous |  Next  |  Index |  Glossary

Privacy/Legal | Copyright 2002 Brio Software, Inc.