Selecting Values for the X and Y Axes

Joined fields are differentiated by color when the join is performed outside of the HTML Graph Assistant, for example in the Join of a Reporting Object. The field list shows fields in different colors based on the Master File they originate from. If you save and then re-open the HTML Graph Assistant, the color assigned to the data may be different than was previously assigned. Note that if a join is in the Master File, joined fields do not show in different colors in the fields list.

Key fields are represented with a key icon in all field lists (tree and list displays) in the HTML Report and Graph Assistant.

The number of fields that are currently displayed shows at the bottom of the fields list. If a field list contains more than 200 fields, the first 200 fields display initially. Additional fields are retrieved and displayed when you select the next set of fields.
To select the next set of fields, scroll to the bottom of the field list and select the Next option that appears. The Next option describes which fields will be returned, for example in the following image it shows that the next 201-400 fields of 417 will be retrieved:

To go back, scroll to the top of the field list and select the previous set of fields. For example, the following image shows the Previous option to select the previous 1-200 of 417 fields:

If you are viewing a Fields List in the Dimension Tree mode and you create a recursive join (joining a file to itself), you will not be able to view the Dimensions in the Fields List after the join is created. This is due to duplication of field names in a recursive join. If you delete the join, you will be able to view dimensions again.

Top of page

Procedure: How to Select Values for the Y-Axis

Click the Field selection tab from the Graph Assistant.

If available, click the List or Tree icon.

Select the field from the Available Fields window and click the Add icon above the Field value(s) plotted on Y-axis fields box.
or

Click and hold the left mouse button, and drag the field to the Field value(s) plotted on Y-axis fields box.

or

Double-click a numeric field to automatically add it to the Y-axis fields box. Note that only numeric fields, which include decimal, floating point, and other formats, are added to the Y-axis.

Optionally, you can use shortcut keys.
Press Alt+C to go the Field value(s) plotted on Y-axis fields box. Then press Alt+M to go to the Available Fields window, tab to the field, and press Enter to add the chosen field.

To add more than one field name at a time:

Ensure the List icon is selected.

Click the field names you wish to include. The fields will highlight as you click on them.

Drag and drop or use the Add icon to add all the selected fields to the Field value(s) plotted on Y-axis fields box.

Note: The display field(s) determines the vertical Y-axis of the graph. When the number of Y-axis labels is greater than one, the labels do not appear along the Y-axis. Instead, they appear in a legend that provides the names of the fields being graphed.

Top of page

Procedure: How to Select Values for the X-Axis

Click the Field selection tab from the Graph Assistant.

Select the field from the Available Fields window and click the Add icon above the Field value(s) plotted on X-axis fields box.
or

Click and hold the left mouse button, and drag the field to the Field value(s) plotted on X-axis fields box.

or

Double-click a non-numeric or date field to automatically add it to the X-axis fields box. Note that only non-numeric fields, which are typically in alphanumeric format, and date fields are added to the X-axis.

Optionally, you can use shortcut keys.
Press Alt+S to go the Field value(s) plotted on X-axis fields box. Then press Alt+M to go to the Available Fields window, tab to the field, and press Enter to add the chosen field.

Top of page

Hiding the Display of a Y-Axis Field

You can hide the display of a Y-axis field in a graph. This option is useful when you want to temporarily remove a particular Y-axis field while retaining all of the original graph properties.

To hide a Y-axis field temporarily, use the Make this field invisible check box located on the subtab of the Show graph field options of the Field Selection tab. By default, the check box is not selected for each Y-axis field. If there are no Y-axis fields, the Show graph field options subtab is disabled.

Top of page

Procedure: How to Hide the Display of a Y-Axis Field

On the Field selection tab:

From the Field value(s) plotted on Y-axis fields box, highlight the Y-axis field you want to hide.

If hidden, click Show graph field options.

Check the Make this field invisible check box.

Top of page

Assigning Characteristics to Y-Axis Values

You can assign a characteristic for each Y-axis field in your graph. In the following table, the first column lists the prefix operators or characteristics, and the second column lists their descriptions.

Summary Type	Description
Field_Name	(Plain field value)
ASQ	Average Square
AVE	Average
CNT	Count
FST	Show first in group
LST	Show last in group
MAX	Maximum
MIN	Minimum
PCT	Percentage
PCT.CNT	Count Percentage
RPCT	Row Percentage
TOT	Total

Top of page

Procedure: How to Assign Characteristics to Y-Axis Values

From the Field selection tab, select Summary Type under Y-axis values.

From the Field value(s) plotted on Y-axis fields box, select the field you would like to assign a characteristic (or prefix operator) to.

If hidden, click Show graph field options.

Select the characteristic from the Summary Type list box.

The field name in the Field value(s) plotted on Y-axis fields box is updated with the appropriate prefix. For example, if you have a field named SEQ_NO, and you select the Average Square summary type, the field name changes to ASQ.SEQ_NO.