version 6.0 (Modified)
GRAPH TABLE {(table)}
or:
GRAPH TABLE ({aTable; }graphType; x field; y field{; y field2; ...; y fieldN})
Parameter | Type | Description | |
aTable | Table | Table to graph, or | |
Default table, if omitted | |||
graphType | Number | Graph type number | |
x field | Field | Labels for the x-axis | |
y field | Field | Fields to graph (up to eight allowed) |
Description
GRAPH TABLE has two forms. The first form displays the Chart Wizard of 4D Chart and allows the user to select the fields to be graphed. The second form specifies the fields to be graphed and does not display the Chart Wizard.
GRAPH TABLE graphs data from a table's fields. Only data from the current selection of the current process is graphed.
Using the first form is equivalent to choosing Charts from the Tools menu in the Design environment. The following figure shows the Chart Wizard, which allows the user to define the graph.
The second form of the command graphs the fields specified for aTable.
The graphType parameter defines the type of graph that will be drawn. It must be a number from 1 to 8. See the 4D Chart graph types listed in the example for the GRAPH command.
Note: The GRAPH TABLE command does not allow the use of the 4D SVG rendering engine.
The x field defines the labels that will be used to label the x-axis (the bottom of the graph). The field type can be Alpha, Integer, Long integer, Real or Date.
The y field is the data to graph. The field type must be Integer, Long integer or Real. Up to eight y fields can be graphed, each set off by a semicolon.
In either form, GRAPH TABLE opens a Chart window for working with the newly created graph. For more information about using the Chart window, see the 4D Design Reference manual.
Note: You can also use the Quick Report editor to generate graphs from field data, by using the Print Destination menu.
Examples
1. The following example illustrates the use of the first form of GRAPH TABLE. It presents the Chart Wizard window and allows users to select the fields to graph. The code queries records in the [People] table, sorts them, and then displays the Chart Wizard:
QUERY ([People]) If (OK=1) ORDER BY ([People]) If (OK=1) GRAPH TABLE([People]) End if End if
2. The following example illustrates the use of the second form of GRAPH TABLE. It first queries and orders records from the [People] table. It then graphs the salaries of the people:
QUERY([People];[People]Title="Manager") ORDER BY([People];[People]Salary;>) GRAPH TABLE([People];1;[People]Last Name;[People]Salary)
See Also