|
| |
Contents | Index
Selecting Subgroups Based on a Set of Criteria
From the Chart Options dialog box, you may choose to limit your analysis to
subgroups matching a set of user defined criteria using the Query text box. For instance, we may want to analyze only those customers waited
on by Tim, or those who didn’t receive material from the ABC Supplier Company, or those who met both
conditions.
If the Show Query Information option is selected in the Preferences dialog box (available from the Options menu), then this query statement will be displayed in the upper right hand
corner of the chart.
You may also use the Query option in conjunction with the Range option. In this case, the query will be performed on the specified row range
only, rather than in all the rows of the data file.
The options within Query include:
- Comparison to a specified condition: In the Query text box, type the condition(s) which the subgroups must meet,
in the form:
column=condition for exact match
column<>condition for not equal to
column>condition for greater than
column<condition for less than
where:
column: is the column label (or letter designation) in the data editor window which
contains the items which the query is based on. It is often less time-consuming
to use the column letter than to type in the text heading. (To display column
letters in the data editor, choose Preferences from the Options menu and check the Show row numbers and column letters box).
condition: is the value (or text) that we want all entries in the column compared to.
Wildcard characters may be used, as follows:
- designates any text string may be substituted at that point.
? designates that any single character may be substituted at that point.
Note:
- Text queries are case-specific, so use capitals just as they appear in the
data editor.
- If the entry includes a space, it must be enclosed in quotations.
- Charting combinations of values or text from multiple columns: Use and between your selections, for example:
D=March and C=Tim
- Charting combinations of values or text from single columns: Use or between your selections, for example:
D=March or D=April
|
