Ref # 656
If you have a Null value (or a missing value in an identifier field), you may want to filter so that only the Null or missing values are included in the result.
For example, the data might look like:
|
Date |
Data |
Defect |
|
1/1/00 |
10 |
|
|
1/2/00 |
12 |
|
|
1/3/00 |
18 |
|
|
1/4/00 |
15 |
Yes |
|
1/5/00 |
12 |
|
|
1/6/00 |
14 |
|
|
1/7/00 |
17 |
|
|
1/8/00 |
13 |
Yes |
|
1/9/00 |
14 |
|
|
1/10/00 |
|
|
To chart only the values where the "Defect" column is blank, use a filter and type in the "Additional Conditions" area the following:
(Defect) is Null <== note the space between "is" and "Null"
