Show/Hide Toolbars

MPCluster for Maptitude

Navigation: Running MPCluster

Applying Data Fields

Scroll Prev Top Next More

MPCluster has the ability to apply dataset data fields to the clustering process. These fields can be used to weight the location of the cluster centers, and to define a constraint sum. Sums and averages of the available fields can also be included in the output Excel workbook. Data fields are applied by setting the Use Data Fields check box in the Input Data box:

 

main_panel_datafields

 

 

Applying a Weight

 

MPCluster positions a cluster's center at the average (mean) location of all the component data points. By applying a weight data field, it is possible to move the centers towards data points with higher weight values. For example, you could be trying to find clusters in customer data in order to find possible locations for new distribution depots. You could use a data field that stores the number of customers as a weight. This will then pull the cluster centers towards the data points with the most customers - so reducing the travel distances.

 

Apply a weight by setting the Use Data Fields check box, and setting the Apply a weight using: check box. This will enable the Apply a weight using: drop down box which lists all of the available numeric data fields in the current dataset. Select the field that you wish to use for the weight.

 

MPCluster will use a weight of 1.0 for all pushpins where the weight field could not be read. This might occur if it has not been set, or it has been set to an unreadable value (e.g. "john" is not a valid weight).

 

 

Applying a Constraint Sum

 

As well as constraining cluster sizes by linear distance and by the number of points, it is possible to constrain them using a data field. Values for this data field are summed for all component data points within a cluster. For a cluster to be valid, this sum is then constrained to be above a specified minimum value and/or below a maximum value.

 

This constraint sum is applied be setting the Use Data Fields check box, and setting the Constrain sum of: check box. This will enable the Constrain sum of: drop down box which lists all of the available numeric data fields in the current dataset. Select the field that you wish to use for the constraint sum. You may use the same data field for both the weight and the constraint sum, if you wish.

 

MPCluster will use a value of 0.0 for all pushpins where the data field could not be read. This might occur if it has not been set, or it has been set to an unreadable value (e.g. "john" is not a valid value for summation).

 

The To: check boxes are also enabled. To set the minimum constraint, set the More than check box and enter the minimum value in the text box that is enabled (2000 in the above example). To set the maximum constraint, set the Less than check box and enter the maximum value in the text box that is enabled (100000 in the above example).