WebFOCUS Online Help: Selecting Values for the X and Y Axes

The values you select for the X- and Y-axes determine what data is included in the graph you are creating, and how it appears.

You can search fields lists. For details, see the Creating Reports With Report Assistant manual.

Note: Field names that contain a hyphen (-) cannot be used in the Graph Assistant.

The following image shows the Field Selection tab, in the Managed Reporting environment, with PRICE selected for the X-axis and CNT_PLANT selected for the Y-axis.

Top of page

Reference: Notes on the Fields List in the Managed Reporting Environment

The following applies to the Fields list in the Managed Reporting environment of the Graph Assistant.

Joined fields are differentiated by color when the join is performed outside of the Graph Assistant, an example of which is 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 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 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 in the Developer Studio Environment

The following applies to selecting Y-Axis values in the Developer Studio environment of the Graph Assistant.

Click the Field selection tab from the Graph Assistant.

Highlight a field in the Fields box and click the Add button above the Y-axis field box. You can also select a field (or fields) from the Fields list and drag and drop it to the Y-axis field box.
To add more than one field name at a time:

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, the labels appear in a legend that provides the names of the fields being graphed.

Top of page

Procedure: How to Select Values for the Y-Axis in the Managed Reporting Environment

The following applies to selecting Y-Axis values in the Managed Reporting environment of the Graph Assistant.

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 in the Managed Reporting Environment

The following applies to selecting Y-Axis values in the Managed Reporting environment of the Graph Assistant.

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 to 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, in the Managed Reporting environment.
Note: In the Managed Reporting environment, if there are no Y-axis fields, the Show graph field options subtab is disabled.
On the subtab of the Graph Field Options of the Field Selection tab, in the Developer Studio environment.

By default, there check box is not selected for each Y-axis field.

Top of page

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

If using the Managed Reporting environment, select the Field selection tab.
If using the Developer Studio environment, select the Field options tab.

In 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.
Note: This step is only applicable in the Managed Reporting environment.

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, in the Managed Reporting environment, or the Field options tab, in the Developer Studio environment, 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.
Note: This step is only applicable in the Managed Reporting environment.

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.