Statistical Context Functions

As described in the context calculation overview, the Statistic functions are designed to provide an easy technique to calculate the basic statistics from the resulting data points in a result set. While these are often done with semantic formulas, they can be much easier to deliver as context logic, because they will change to suit the selections made in a report or visual - which is often more efficient.

Statistics Logic

The core principal behind statistic calc's is to read all the data points in a query and easily compute basic statistical values. Although these values can be derived in alternative ways (via totals, semantic calculations etc), the key elements driving the math look at the list of items (from a hierarchy) and the selected metric. By changing the hierarchy or the selections, the statistic will change accordingly, without needing to redefine or recode the calculation itself (i.e. its contextual).

However, if the contextual resolution of the statistic logic requires further refinement, it is possible to edit the behavior of the calculation using the Context Calculation Logic Editor.

  • Click here to learn about the Context Calculation Logic Editor


Editing Context Calculation Logic

As well as editing and changing the properties of a context calculation, such as its name or format, it is also possible to alter the logic of how the calculation is performed using the Context Calculation Logic Editor.