Refining the Data Set For Your Graph

After selecting field values for the X and Y axes, you may wish to limit the data that displays in your graph. You can do this by creating WHERE statements. A WHERE statement limits data by creating parameters the data must satisfy before it is included in the data set.

For details on WHERE, WHERE TOTAL, and IF phrases, see Selecting Records for Your Report.

Example: Specifying WHERE Criteria in a Graph Request

The syntax for WHERE, WHERE TOTAL, and IF phrases in a GRAPH request is identical to that used in a TABLE request.

The following graph request shows data for specific product descriptions, namely French Roast, Hazelnut, or Kona.

GRAPH FILE GGORDER
SUM QUANTITY 
BY PRODUCT_DESC
WHERE PRODUCT_DESC EQ 'French Roast' OR 'Hazelnut' OR 'Kona'
END

The output is: