Hot-Spots Guide - Manipulate

 

Filtering Hot-Spots data 

 

Video Guide

Step One

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. 

Step Two

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. 

Step Three

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.  

Step Four

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. 

Step Five

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. 

Calculating a new data column 

 

Video Guide

Step One

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. 

Step Two

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. 

Step Three

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. 

Step Four

Name the new data column - To name your new data column, open the Name section and type a name in the box. 

Step Five

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.

Step Six

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. 

Step Seven

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. 

Step Eight

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 for Hot-Spots 

 

Video Guide

Step One

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. 

Step Two

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. 

Step Three

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. 

Step Four

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. 

Step Five

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. 

Step Six

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.