Selecting Values for the X and Y Axes

In this section:

How to:

Reference:

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

You can also:

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.

Field Selecion tab MR

The following image shows the Field Selection tab, in the Developer Studio environment, with STORENAME selected for the X-axis and LINEPRICE selected for the Y-axis.


Top of page

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

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


Top of page

x
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.

  1. Click the Field selection tab from the Graph Assistant.
  2. Highlight a field in the Fields box and click the Add Add field button 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:

    1. Press the Ctrl key.
    2. Click the field names you wish to include.
    3. Drag and drop or use the Add button Add field button to add all the selected fields to the Y-axis field 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, the labels appear in a legend that provides the names of the fields being graphed.


Top of page

x
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 Reportingenvironment of the Graph Assistant.

  1. Click the Field selection tab from the Graph Assistant.
  2. If available, click the List or Tree icon.
  3. 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.

  4. 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, Tab 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:

  1. Ensure the List icon is selected.
  2. Click the field names you wish to include. The fields will highlight as you click them.
  3. 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

x
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.

  1. Click the Field selection tab from the Graph Assistant.
  2. 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.

  3. 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, Tab to go to the Available Fields window, tab to the field, and press Enter to add the chosen field.


Top of page

x
Hiding the Display of a Y-Axis Field

How to:

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:



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

On the Field selection tab:

  1. In the Field value(s) plotted on Y-axis fields box, highlight the Y-axis field you want to hide.
  2. If hidden, click Show field options or Display in Developer Studio.

    Note: This step is only applicable in the Managed Reporting environment.

  3. Check the Make this field invisible check box.

Top of page

x
Assigning Characteristics to Y-Axis Values

How to:

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

SUM

Sum

TOT

Total



x
Procedure: How to Assign Characteristics to Y-Axis Values
  1. From the Field selection tab in the Managed Reporting environment, select Summary Type under Y-axis values.
  2. 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.
  3. If hidden, click Show field options or Display in Developer Studio.

    Note: This step is only applicable in the Managed Reporting environment.

  4. 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.


WebFOCUS