The
Filter to Include Rows
field is an optional parameter that
enables you to filter the rows in the data set. Only those rows that meet all of the conditions specified are included in the analysis.
For example, to filter only diseased individuals from a data set containing a mixed
population
of diseased (sick) and healthy (healthy) individuals (as indicated in a column named
DiseaseStatus
), you could use the following simple WHERE expression:
Note:
the word
where
has already been entered for you.