Build advanced Models using simplified Formula Builder and Modeller by applying traffic lighting!

We recommend you watch the video to get started!

This article covers the following topics

Build advanced formulas using simplified formula builder
Mapping and Calculation
Traffic lighting and simulation

Mapping and Calculation 

Metric data displayed in Concerto can either be mapped to a data source or calculated via formula.

To build the formula, click on the Mapping and Calculation tab and then select the Manual Data Entry inside the Data and Calculation tab as shown in the image below.

Follow the steps to build your advanced formulas;

Feature can be found in: Modeller > Mapping & Calculation tab > Population: 'Calculation' > Calc Type: 'Advamced Formula Builder'

Refer to the image below

Building the Formula

You can select the values of your choice by simply selecting it from the calculator.  

Advanced formula builder

To build the advanced formulas, you can select the node, parent or child under this tab.

Calculations

Below is the result of your calculation

Traffic lighting and Simulation 

Traffic lighting configuration including thresholds for a specific metric. Controls simulation behaviour for a specific metric at a key figure level.

To access the Traffic lighting and Simulation tab, Click on the Traffic lighting and Simulation tab inside the Modeller tab as shown in the image

Refer to the image below

Worksheet

Controls Concerto Worksheet display properties for a specific metric.

When checked, metrics displays in Concerto Worksheet, otherwise metrics are suppressed.

Refer to the image below