Adding a Calculated Measure to a Dashboard

Calculated Measures functionality is available on all dashboard visualisations. However, in its current form it is most suitable for displaying headline figures on the number card.

As with all dashboard features, adding or amending begins with editing a Dashboard. In this example a new tile is added but Calculated Measures can be applied to an existing Dashboard tile by deleting the existing measure, ready to add a new Measure in its place.

Note: Calculated measure values may differ between FastStats and Orbit. This is due to rounding calculation process that occurs in FastStats. The value provided in Orbit is more accurate to a higher level of precision.

To add a new tile applying calculated measures:

1. Rather than choosing the + Measure option, click on the Calculated Measures icon on the right hand side of + Measure.

   

2. By selecting this icon, you can choose two measures to be applied together to form one resultant Measure.

   

3. Click on the Search data fields to add either a data variable or a table to the Measure.

   

4. Choose the appropriate operator: add, subtract, multiply, or divide by selecting the drop down menu in between the two Measures.

   

5. Then search or select the data table or variable you wish to use for the second Measure in the calculation. You can choose to show the result of the calculation as a percentage by placing a tick in the Show as a Percentage option.

   

   Note: When adding a measure or calculated measure to a visualisation, you can choose to display its labels with decimal places ranging from 0 to 2.

6. Once the Calculated Measure has been created, carry on amending the other Tile options as appropriate, and give the tile a name to enable the Apply button.

   

   Note: To assist with understanding the impact of using different data variables which describe different data types and therefore may sit in different data tables within your data structure, there is a Help Icon within this feature, which takes you straight to more explanation on this topic.

   

7. Once the tile has been created, click Save to save the dashboard with the new Measure in place.

   

See Designing dashboards with calculated measures.