Altering the size of points according to their associated values
This tip will allow you to change the size of a point depending on the value associated with it. The larger the figure or value, the larger the size of the point. This comes in handy if you have a list of customers and want their point size to reflect the amount of money they spend in a store.
To alter a point’s size:
Open your map, right click and select Add Layer
Use the drop down next to Schema to find the schema that contains the points you want to plot on the map
Select Next then click on the Select button next to Geometry Expression
Delete the current expression from the Expression box at the top of the window
In the Expression box type:
Circle(MASTER.POSTCODE_POINT, MASTER.SPEND ,2)
Where
MASTER.POSTCODE_POINT = the geographic point column, found in the Master Table
MASTER.SPEND = the column that contains the values you want to use to alter the point size (e.g. Customer Spend, Square Footage, Count etc.)
2 = the distance units (1 = Kilometres, 2 = Metres, 3 = Miles)
Set the Layer Type to Area
Select the OK button then click on Create
Note: If your circles are too big, divide the value by 100 to get a smaller figure, thus a smaller circle
Last updated