Indicator Tutorial (Solar Panels): Difference between revisions

From Tygron Support wiki
Jump to navigation Jump to search
(Created page with "This tutorial guides you through the steps that are necessary to build your own simple Indicator using excel. In this example, an Indicator is build that calcula...")
 
No edit summary
Line 1: Line 1:
This tutorial guides you through the steps that are necessary to build your own simple [[Indicator|Indicator]] using excel.
This tutorial guides you through the steps that are necessary to build your own simple [[Indicator|Indicator]] using [[Excel|excel]] and [[TQL|TQL]].
In this example, an Indicator is build that calculates the amount of (different kinds of) houses with solar panels that are present in a neighbourhood.  
In this example, an Indicator is build that calculates the amount of (different kinds of) houses with solar panels that are present in a neighbourhood.  


the steps to be taken are:
the steps to be taken are:
- Check which (housing) functions with solar panels are present in the {{software}}
* Check which (housing) functions with solar panels are present in the {{software}}
- Compose the right TQL query necessary tot determine the amount of housing functions with solar panels per neighbourhood
* Compose the right TQL query necessary tot determine the amount of housing functions with solar panels per neighbourhood
- Think of how you want to show the results in a table and fill in the html table according to this
* Think of how you want to show the results in a table and fill in the html table according to this
- Test the Indicator
* Test the Indicator


- Potential upgrade of your Indicator: add a column with the resources provided with the Solar Panels. Make an assumption for the resources per house with Solar Panels.  
- Potential upgrade of your Indicator: add a column with the resources provided with the Solar Panels. Make an assumption for the resources per house with Solar Panels.  


An example of an Indicator that was build following these steps can be found in the [[https://store.tygron.com/ Tygron Index]]
An example of an Indicator that was build following these steps can be found in the [https://store.tygron.com/ Tygron Index] named 'Houses with Solar Panels'

Revision as of 12:19, 3 May 2019

This tutorial guides you through the steps that are necessary to build your own simple Indicator using excel and TQL. In this example, an Indicator is build that calculates the amount of (different kinds of) houses with solar panels that are present in a neighbourhood.

the steps to be taken are:

  • Check which (housing) functions with solar panels are present in the Tygron Platform
  • Compose the right TQL query necessary tot determine the amount of housing functions with solar panels per neighbourhood
  • Think of how you want to show the results in a table and fill in the html table according to this
  • Test the Indicator

- Potential upgrade of your Indicator: add a column with the resources provided with the Solar Panels. Make an assumption for the resources per house with Solar Panels.

An example of an Indicator that was build following these steps can be found in the Tygron Index named 'Houses with Solar Panels'