Expression Measures

FastStats expressions are used to calculate values for tables, cubes, and other visualisations. They can be used anywhere that there is a measure in a dashboard tile.

This is a feature for advanced dashboard editors to be used where standard measures or calculated measures have reached their limits, and more bespoke calculations are required.

Which expressions are supported in Expression Measures?

As this is a measure, only expressions that result in numbers can be used. Also, Derived Cube Expressions and Cube Lookups are not supported, as there is no cube to refer to. Expressions cannot refer to queries, and Aggregation functions cannot be used.

Adding an expression measure to a dashboard tile

The following example creates a table showing the average distance to Apteco’s Warwick office of households by UK region.

Create a table visualisation

First, add a tile with a table visualisation and choose a dimension. In this example the dimension is Region:

The count of households is set as a measure by default. Remove this measure by clicking the cross that appears when the mouse hovers over the element:

Adding an Expression Measure

Click on the empty measure to set a new measure. At this point expression measure details are opened.

From here you can enter the expression measure details:

Expression measure details:

  • The Name field is used for column headings or axis descriptions where the expression measure is being used

  • The Resolve Table of the FastStats system calculates the expression

  • You can type or paste a FastStats expressions in the Expression field

If you are an Apteco FastStats user, then you can create the expression in FastStats and paste it here to make full use of the advanced features.

When you click Apply, Orbit attempts to validate the expression.

Note: There are certain situations where Orbit can’t correctly identify an expression as invalid. A more detailed description of the limitations of Orbit’s Expression Measure Validation is also available.

Choosing the function

The expression calculates a number (or missing value) for every row in the underlying data. You can choose how to summarise these numbers in each cell of the table. In our example, we’re displaying the mean of each result in the table cells for each region, so we choose Mean.

The result

Completing and applying the remaining settings results in a table is displayed below.