Use the segmentation features to identify a subset of a population. You can then perform further analysis by focussing solely on this subset of records.
There are two options for creating segments: Segmentation and Analyse Segment.
Use this feature to create segmentation recodes. This is where you recode a field based on the values of that field used by the records that contribute to a selection of cells.
For example, you have a table showing customer gender by product type:
You want to investigate further the locations where females with the credit card product live:
- Click the Female/Credit Card cell to select it:
- Right-click and select Records > Segmentation. The Segmentation dialog displays.
- In the Name field, enter a name for the segmentation recode. This will be displayed in the Fields window. It must be unique within the current database (it cannot be the same as an existing field, recode, or user defined field).
In the Table and Field drop-down lists, select the field you want to create the recode for.
In this example, select the Customers table and the Area field. SuperCROSS will create a recode for the Area field that contains just the postcodes used in the (in this case) 16,610 records that contribute to the selected cell.
- Keep Selected Cells selected.
SuperCROSS creates two recodes of the Area field. The singly recode lists each value separately, while the group recode contains all the values grouped together:
You can now use these segmentation recodes for further analysis.
As an alternative to creating a segmentation recode, you can use the Analyse Segment function to drill down into a particular cell in the table for further analysis.
To use this feature:
- Click a cell to select it.
- Right-click the cell and select Records > Analyse Segment.
SuperCROSS creates a new table that is pre-filtered so that it only contains records matching the cell you clicked on. You can now add fields to the axes to further analyse the members of this population.
Analyse segment is different to creating a segmentation recode in that it only contains those records from the cell it was created from.
Using the example from the previous section, if you right-click the cell for female customers with credit cards and select Records > Analyse Segment, SuperCROSS creates a new table filtered to show only those records. You can now add fields to this table to analyse this subset of data. For example, you might choose to add the Area field. In this example a Grand Total has also been added to show that the new table is restricted to just the 16,610 records from the selected cell: