Grid Overlay Area Measurement (Panel): Difference between revisions
No edit summary |
No edit summary |
||
| Line 1: | Line 1: | ||
Template panel that can be applied on Areas. This excel calculates and creates a line charts of Grid Averages within a specific Area per timeframe for a Grid Overlay. | |||
The Grid Overlay is identified by specifying the Attribute "AREA_MEASUREMENT" with a value 1. | |||
How to use: | |||
- Add a new Template Excel Panel by hovering over Panels in Current Situation in the Editor. | |||
- Click on the Select Excelsheet button for this Panel. | |||
- Click on the 'Add Geoshare File' button | |||
- Select Public share and browse to the Panels folder and select this file. | |||
- Select the imported Excel Sheet for this Panel. | |||
- Select the Template tab in the details of this Panel and specify on what Areas it should be applied. Optionally with specific Attribute. | |||
- Click on the Apply Template button to create the Panel instances. | |||
- Select Overlays in the ribbon bar and select the Grid Overlay that should be measured. | |||
- Select the Attributes tab of this overlay and add a new Attribute named "AREA_MEASUREMENT" with a value 1. | |||
- Hover over the Calculation Cloud option in the Ribbon bar and select Reset Excel X-Queries to calculate the Templated Excel Panels. | |||
Requirements: | |||
Requires Plotly library. Javascript lib is automatically imported for html panels using: <script src="https://cdn.plot.ly/plotly-latest.min.js"/> | |||
Restrictions: | |||
Only applicable on Areas | |||
Currently up to 365 Overlay timeframe are supported.any greater than 0). | |||
{{Panel nav}} | {{Panel nav}} | ||
Revision as of 11:15, 7 May 2025
Template panel that can be applied on Areas. This excel calculates and creates a line charts of Grid Averages within a specific Area per timeframe for a Grid Overlay.
The Grid Overlay is identified by specifying the Attribute "AREA_MEASUREMENT" with a value 1.
How to use: - Add a new Template Excel Panel by hovering over Panels in Current Situation in the Editor. - Click on the Select Excelsheet button for this Panel. - Click on the 'Add Geoshare File' button - Select Public share and browse to the Panels folder and select this file. - Select the imported Excel Sheet for this Panel. - Select the Template tab in the details of this Panel and specify on what Areas it should be applied. Optionally with specific Attribute. - Click on the Apply Template button to create the Panel instances. - Select Overlays in the ribbon bar and select the Grid Overlay that should be measured. - Select the Attributes tab of this overlay and add a new Attribute named "AREA_MEASUREMENT" with a value 1. - Hover over the Calculation Cloud option in the Ribbon bar and select Reset Excel X-Queries to calculate the Templated Excel Panels.
Requirements: Requires Plotly library. Javascript lib is automatically imported for html panels using: <script src="https://cdn.plot.ly/plotly-latest.min.js"/>
Restrictions: Only applicable on Areas Currently up to 365 Overlay timeframe are supported.any greater than 0).