**Fact Builder**

There are five different types of fact:

Simple - A calculation that produces a numeric or date result based on a fact. There are five simple fact types all accessed by clicking "SUM" and selecting from the dropdown.

• SUM adds all of the values within each dimensional grouping. It uses the basic arithmetic operators +, -, *, and /, to build an expression as well as parenthesis, (), to enforce precedence.

• MIN returns the smallest value in the Fact results and allows string concatenation

• MAX returns the largest value in the Fact results and allows string concatenation

• AVG returns the arithmetic mean (average) of the values in the expressions results

• COUNT returns the number of source elements in the expression (as grouped by the Smart Column's levels)

Embedded - Incorporates simple Facts within a larger expression and gives the result. E.g. multiply the result of a SUM by the result of a COUNT. Each simple fact component should be built within the Embedded fact itself.

Threshold - Compares the result of a simple expression against a Threshold, and returns the corresponding Pick state

Free Form Threshold - Similar to the Threshold Fact type but allows you to define your own thresholds using a picklist.

Aggregated Pick State - Return the min or max Pick List state for a Pick List. Can be used to show the extreme cases to be found within a group of elements. min and max values are determined by the order of states within it i.e. top Pick List value is min and bottom is the last.

For a more detailed explanation on Facts and the Fact Builder see Aggregation - Facts.

## Comments

1 comment

Hello, could do with a worked example of thresholds. I'm currently doing an example but not quite getting the results I'm hoping. Thanks

Please sign in to leave a comment.