Segmenting by query
The segment by query option segments your data based on the results of a query that you create. This option is most useful when it is necessary to filter the data in a field to create the required segments.
For example, assume that you want to divide your customers into high-value (more than $500), medium-value ($250-$500), and low-value (under $250) segments based on their purchase history over the last year. The PurchaseHistory field in your customer database stores the total dollar amount of each customer's purchases. Use a separate query to create each segment, selecting records with values in the PurchaseHistory field that meet the criteria of the segment.
*
You can also segment data using raw SQL.
Copyright IBM Corporation 2015. All Rights Reserved.