Calculation panel: Difference between revisions

From Tygron Support wiki
Jump to navigation Jump to search
No edit summary
No edit summary
Line 5: Line 5:
Below an explanation of the difference between the two options:
Below an explanation of the difference between the two options:


Most of the time, in an Excelsheet [[Excel#X_Queries]] are used. If you have for example three areas in your project, an X query would be as follows:   
Most of the time, in an Excelsheet [[Excel#X_Queries||X Queries]] are used. If you have for example three areas in your project, an X query would be as follows:   
SELECT....WHERE_AREA_IS_X.
SELECT....WHERE_AREA_IS_X.
In the Engine this query is translated to the following three queries:
In the Engine this query is translated to the following three queries:

Revision as of 13:33, 26 January 2018

Recalculate indicators is an option in the editor menu bar that will allow you to reset how indicators and panels are calculated. There are two options to recalculate indicators and panels.

  • Reset to Start Values
  • Reset X Queries

Below an explanation of the difference between the two options:

Most of the time, in an Excelsheet |X Queries are used. If you have for example three areas in your project, an X query would be as follows: SELECT....WHERE_AREA_IS_X. In the Engine this query is translated to the following three queries: SELECT....WHERE_AREA_IS_0 SELECT....WHERE_AREA_IS_1 SELECT....WHERE_AREA_IS_2

When using Reset to Start Values, for example if you changed an attribute of one o these areas, the three queries are recalculated. If you choose Reset X Queries, the X Query is again translated to queries. If you for example added a new area, in the Engine the X Query is then translated to: SELECT....WHERE_AREA_IS_0 SELECT....WHERE_AREA_IS_1 SELECT....WHERE_AREA_IS_2 SELECT....WHERE_AREA_IS_3

If you used Reset to Start Values in this case, the fourth area was not taken into account, since the three queries would be recalculated again and the Engine would not check if an area was added or removed.

When to choose which option?

Choose Reset to X Queries if the amount of areas or neighborhoods is changed (for example by adding of removing an area). Choose Reset to Start Values if the amount of areas or neighborhoods stays the same (for example if you only changed an attribute of an area or if you did not use X Queries in your Excelsheet.

Using one of these two option affects all indicators (and panels).