Filter a Hot-Spots layer - To filter your own data, Open an existing project and then My Data, click on the layer you wish to filter.
Open the filter tool - Within the layer editor panel select Data, from here you can control the data associated with your Hot-Spots, expand the Filter selection panel.
Apply a filter
To apply a filter to your Hot-Spots based on a column within you data, choose the following:
Column - select the column you wish to filter from the first dropdown box.
Operation - select the type of filter operation you wish to apply. The operation options you have vary depending on the data type of the column that you have selected.
Value - Enter a value to base your filter on. If your column is a character field, you can start to type the first few letters of the required filter and then select an option from the dropdown list. If your column is numeric you can use the slider to select a value or type a value into the text box. If your column is a date, a calendar will be displayed when you click in the value box so that you can select a date.
Click Apply once you have created your filter, then the map and the data view will automatically update. To check the features that match the filter criteria, open the Data View by clicking on the data grid button at the bottom left of the map.
Create additional filters - You can add up to five filter criteria by pressing the + button and selecting an AND or OR operator from the dropdown box to combine the filters. Press Apply to apply the filter and show the results in the data view and on the map. To remove a filter line press the – button. To clear the filter so that all records are selected again, press the Clear button.
Filter layer indicator - If you press the Project arrow to return to the project panel, and open the My Data section, there will be a filter icon next to any layer that has a filter applied to it. This is a useful reminder if you save your project and open it at a later date.
Edit a layer - To edit your own data, Open an existing project and then select My Data, click on the layer you wish to edit.
Select all Catchments - Before a data column can be added to a layer, all Catchments in the layer must be selected. To check this, open the Select section of the panel and make sure that the All button is selected.
View data columns - Within the layer editor panel select Data, from here you can control how the data is displayed in the Data View, then select Columns to display a list of all the data columns that are currently available in your layer.
Add a new data column - To add a new data column, click on the + button (underneath the list of columns). A warning message will be displayed to let you know that the layer will automatically be saved if you add a new column. Choose Yes to continue.
Name the new data column - To name your new data column, open the Name section and type a name in the box.
Choose a data type - You can choose from several different data types by opening the Data Type section and selecting the required type from the dropdown list.
Change the data format - Depending on which data type you have chosen, you may find a Format section which will allow you to specify how you want your data to be formatted. Change the formatting if required.
Build the data expression - To build your data expression, open the Expression section, select the type of calculation from the dropdown list and then use the dropdown boxes to create the expression for your new data column. The types of expressions you can choose from are:
Simple Calculations – Allows you to add, subtract, multiply or divide existing columns in your layer
Aggregation Calculations – Allows you to calculate the Sum, Average, Variance or Standard Deviation .of an existing column in your layer.
Cartographic Calculations – Allows you to calculate the X/Y co-ordinates of each feature, and for areas, the surface area in square kilometres, miles, metres or yards.
Percentage Calculations - Allows you to identify a percentage value of an existing column in your layer.
Press Calculate to add the new calculated column to your layer.
View your new data column - To look at the new data column, open the Data View by clicking on the data grid icon (bottom left of map). Your new column will appear after the existing data columns in your layer.
Editing data in a Hot-Spots layer - To edit your own data, Open an existing project and then select My Data. Click on the layer you wish to change.
Editing the data - Within the layer editor panel select Data, from here you can control the data associated with your Hot-Spots, expand the Columns selection panel.
Changing which columns are displayed
You can control the columns that are displayed in the Data View by ticking/un-ticking the boxes next to each column name.
You can delete a column by clicking the X. Some columns, like the ID, cannot be deleted.
You can add a column by clicking the + button.
Column configuration
To edit a column, click on the column name and the panel will update to show the Column Configuration Panel.
You can change the name of the column by clicking in the name box and typing.
You can change the data type of the column by selecting from the dropdown box.
For numeric columns, you can set the data format, e.g. the number of decimal places or special formats such as time or date.
Changing the data expression - To edit a column with a calculation, open the Expression section, select the type of calculation from the dropdown list and then use the dropdown boxes to build your calculation. The type of expressions you can choose from are:
Simple Calculations – Allows you to add, subtract, multiply or divide existing columns in your layer.
Aggregation Calculations – Allows you to calculate the Sum, Average, Variance or Standard Deviation of an existing column in your layer.
Cartographic Calculations – Allows you to calculate the X/Y co-ordinates of each feature, and for areas, the surface area in square kilometres, miles, metres or yards.
Percentage Calculations - Allows you to identify a percentage value of an existing column in your layer.
Click Calculate, the values will appear in the column in Data View.
Viewing your new data column - To look at the new data column, open the Data View by clicking on the data grid icon (bottom left of map). Your new column will appear after the existing data column in your layer.