Specifications

CHAPTER 13 Working with Graphs
Users Guide 413
Specifying the categories
Specify the column or expression whose values determine the categories. In the
Graph Data page in the Graph dialog box and on the Data page in the Properties
view, you can select a column name from a drop-down list.
There is an entry along the Category axis for each different value of the column
or expression you specify.
Using display values of data
If you are graphing columns that use code tables, when data is stored with a
data value but displayed to you with more meaningful display values, by
default the graph uses the column’s data values. To have the graph use a
column's display values, use the
LookupDisplay InfoMaker expression function
when specifying Category or Series.
LookupDisplay returns a string that
matches the display value for a column:
LookupDisplay ( column )
For more about code tables, see “Defining a code table” on page 284. For more
about LookupDisplay, see LookUpDisplay on page 701.
Specifying the values
InfoMaker populates the Value drop-down list. The list includes the names of
all the retrieved columns as well as the following aggregate functions:
•
Count for all non-numeric columns
•
Sum for all numeric columns
Select an item from the drop-down list or type an expression (in the Properties
view). For example, if you want to graph the sum of units sold, you can specify:
sum(units for graph)