How to combine multiple calculations into a single result

From Tygron Preview Support Wiki
Jump to navigation Jump to search

How to combine multiple calculations into a single result:
  1. Hover over Overlays in the ribbon bar.
  2. Hover over Grid Calculation under Add New, and select Combo.
  3. For Grid A, select a Grid Overlay
  4. For Formula, write AT if you want to collect all timeframes, A if you only want to collect the last timeframe.
  5. Click on the update link to initialize the Combo Overlay
  6. Select the Attributes tab
  7. In the Add new Attribute name field, write SKIP_NO_DATA
  8. In the Add new Attribute value field, write 1
  9. Click on the Save new Attribute button.
  10. Hover over the Calculation Cloud in the ribbon bar.
  11. Select the option Reset Excel X-Queries.
  12. The Combo Overlay is now setup to accumulate overlay results.


Subdivision Areas with Margin

Some Overlays require a Margin around the limited area to be calculated correctly. For Example, for an Average Overlay calculation the margin should be set to average distance. Note however that the calculated values that lie within the margin, but outside of the subdivision area, should be ignored by the accumulating Combo Overlay.

This can be achieved by configuring an Area Input Attribute for the Combo Overlay on the Subdivision Attribute. Secondly, the user must deactivate all subdivisions except the one that should be calculated during limited calculation. Thirdly, the Combo Overlay formula must take into account the active Subdivision, which can be achieved by using the following formula:

IF(@A, AT, NO_DATA)
How to Combine multiple calculations with a margin:
  1. Select the Combo Overlay constructed using the howto above.
  2. In the Input Tab, with the input option set to Attirbute:Specific Layer, select AREAS.
  3. For Attribute A, select the SUBDIVISON attribute.
  4. Select the General Tab
  5. Adjust the formula to IF(@A, AT, NO_DATA).
  6. For each calculated subdivision, follow these steps:
  7. Deactivate all Subdivision areas.
  8. Activate one specific Subdivision Area.
  9. Hover over the Calculation Cloud and select the option Limited Box (or Entire Map when it is the first time)
  10. In the Popup, select to adjust the limitation.
  11. Adjust the limit margin if not yet set.
  12. Select the activated Subdivision Area, chosen in a previous step.
  13. Click on the Calculation Cloud to calculate that subdivision.