Indicator

Overlay in comparison to Measurements, Indicators and Globals

Indicators are named after Key Performance Indicators, which serve as a means to identify potential improvements and as a metric for the degree to which those improvements have been successful.

Indicators are visible at the top of the interface. Each indicator has a short name and, except for the budget, a progress bar showing current performance. Indicators can also be inspected by clicking on its element in the top bar, which opens the indicator panel.

Score

The progress made on an indicator depends on the absolute score setting of the indicator:

• When selected, the progress is based on the absolute score.
• When not selected, the progress is relative to the calculate score in the current situation. Such an indicator will measure the relative improvements.

In the indicator panel, the indicator's full name is shown in the title, along with a description and indicator progress on the left. On the right part of this panel a calculated score and an EXPLANATION are shown. The score and EXPLANATION are produced by the indicator's Excel Sheet. This Excel sheet calculates a score and explanation, placing them in designated cells. The excel sheet is also able to obtain information from a project using Tygron Query Language (TQL) statements. A change in the project state provides input to the indicator, the indicator spreadsheet performs calculations based on this input and displays the result as output in the indicator and progress panel on the top bar.

To better understand the implementation of the Excel Indicator, please follow the Indicators Tutorial.

Detail from sample Indicator Excel File

The following output labels can be used to show text or numbers in the indicator panel at the top bar.

EXACT_NUMBER_VALUE: A numerical value that is formatted using the unit system selected for your project. Replaces the indicator's progress bar.

EXACT_TEXT_VALUE: A text value that will be used instead of the progress bar.

Influencing Indicators

During a session, users' actions can influence Indicators, directly by spatial adjustments and spatial TQL statements and indirectly through Grid Overlay results and subsequent Grid TQL statements. It is up to the users to adjust their actions to improve the score on their Indicators. Also note that an action can also have effects on personal indicators of other stakeholders. For example, if a project developer creates a large office park where there previously was a forest, the amount of green will go down, which will negatively affect the goals of a municipality.

Improving the green indicator by planning a forest of deciduous trees. The improvement is shown in green in the Action log panel.

The current situation (original) and maquette (planned) situation can be compared by switching between these situations using the buttons in the top bar.

Current situation of the green indicator when planning a forest of deciduous trees. Notice the selected original button in the top bar.

Maquette situation of the green indicator when planning a forest of deciduous trees. Notice the selected planned button in the top bar.

Indicators on the GeoShare

You can also import indicators from the GeoShare. There is a set of indicators made available in the Public Share. It is also possible to import indicators from GeoShare of your domain. Default public share indicators have wiki pages explaining any required project adjustments upon import. For example, some indicators require specific Indicator attributes, an Overlay, or Areas to function.

• 
  The default indicators shown in the indicators tab in the editor.
• 
  The indicators shown in the public GeoShare.

The available default indicators are listed below. Some of these indicators already perform specific calculations and can be directly used in the project. They can also be modified and extended with adjusted calculations.

It is also possible to implement your own indicator, using an Excel file. This Excel file should be imported into your project and assigned to an indicator. Each added indicator is initially empty, and will require some work to set up, but it is highly customizable.

Relation to stakeholders

By default, when adding an indicator, it is visible to and accessible by all stakeholders, through an icon in the top bar. Access to an indicator can be restricted when it is made personal; a link to a stakeholder can be configured for an indicator. This stakeholder is then considered the owner of the indicator.

For more information on adding and removing indicators to stakeholders, see stakeholders.

This relationship between an indicator and its personal stakeholder can be queried using TQL with the Relation parameter:

• Stakeholder name: SELECT_NAME_WHERE_INDICATOR_IS_17_AND_RELATION_IS_OWNER
• Stakeholder id: SELECT_ID_WHERE_INDICATOR_IS_17_AND_RELATION_IS_OWNER

When using an excel for an Excel Indicator, you can also access the stakeholder directly using:

• Stakeholder name: SELECT_NAME_WHERE_STAKEHOLDER_IS_ID
• Stakeholder id: SELECT_ID_WHERE_STAKEHOLDER_IS_ID

A personal heat indicator for the municipality. It is only visible in the top bar for this specific stakeholder.

Upload an Excel file

To upload an Excel xlsx-file for the Excel Indicator, have the file ready on an easy to remember location (desktop for instance), and add in the Editor an Excel indicator to the project. Select Excel File Name on the left panel and select the Upload button on the right panel. In the newly opened panel, select the file to upload and confirm. Now the file has been uploaded to the project, and the new indicator has appeared on the top bar. If there was already a previous version of the file present, please select the Recalculate Indicators option from the Indicators drop down menu, to ensure the newly uploaded spreadsheet has an actual impact on the project.

How to upload an Excel Indicator:

1. Select Indicators > Add Excel Indicator
2. Rename the newly added indicator in the 'Name' and Short Name' fields on the right panel
3. Select the color to be used in the progression panel
4. Select to activate the indicator, if desired
5. Add a proper description
6. Highlight 'Excel File Name' on the left panel panel
7. Select the 'Upload' button
8. Select the file to upload in the 'Choose your file' panel
9. Select Indicators > recalculate Indicators

• 
  1. Select Indicators > Indicators > Add Excel Indicator
• 
  2. Enter new Name and Short Name
• 
  3. Change color of the indicator
• 
  4. Activate the indicator
• 
  5. Add a description
• 
  6. Highlight 'Excel File Name' on the left panel
• 
  7. Select the 'Upload' button
• 
  8. Select the file to upload in the 'Choose your file' panel
• 
  9. Recalculate the newly added Excel indicator

How-to's

• How to add or remove or duplicate an Indicator
• How to edit Indicator properties
• How to edit Indicator targets
• How to configure a Query for an Excel Indicator
• How to make the Green Garden Indicator
• How to manually adjust Indicators in Excel
• How to use the Query Tool to test queries from an Excel Indicator spreadsheet
• How to change Function Values for a Function, to adjust the effects actions have on Indicators.
• How to make an Indicator visible to only one stakeholder

Videos

See also

• Excel Indicator
• Indicators Tutorial
• TQL
• Plotly

API Endpoints

• Api session items indicators
• Api session event editor indicator

External links

• TQL and Indicators Webinar

---

Current Situation

Current Situation

Buildings • Terrains • Administrative • Areas • Networks • Overlays • Indicators • Panels • Globals •  Queries • Geo Import

Buildings

Function • Function Override • Section • Category • Custom Geometry • Category Value • Function Value • Function Values Table • List of Functions

Traffic

Unit Type • Unit Data • Unit Data Override

Terrain

Height sector • Elevation model • Elevation GeoTIFF • Elevation Grid Overlay • Ground Price • Terrain Type • Terrain Type Override • List of Terrain Types

Administrative

Neighborhood • Zone • Permission Popup • Plot • Zip Code

Queries

Query Tool • Measurement

Geo Import

Source • GeoShare

Network

Net Cluster • Net Function • Net Line • Net Load • Net Node • Net Setting

Editor

Current Situation • Future Design • Multi Scenario • Tools • Community

---

Indicators

Basics

Excel • Indicators Tutorial • TQL • TQL Tutorial

Public Share

Climate adaptation • Green • Green MKP • Health • Heat Reduction • Heat risk • Housing target • Industrial runoff • Livability Housing • Parking • Risk contour • Solar panels • Student housing target • Traffic health impact • Traffic Noise • Water stress • Wind turbine

Tools

Plotly