Graphs

1. Access a Graph.
2. In the upper-right corner of the page, select Create New.

   The Data Source workspace appears.

   

3. Select the data source for the graph.
4. Specify the dimensions for the graph.
5. In the upper-right corner of the page, select .
   Tip: You can also select to save the graph in a different location.

   The graph is created, and stored in the specified Catalog folder.

1. Access the Catalog page for the folder containing the graph that you want to copy.
2. Select the check box that corresponds to the graph that you want to copy.
3. In the upper-right corner of the workspace, select .

   The Catalog Folder Browser window appears.

   

4. Navigate to the folder where you want to copy the graph, and then select Done.

   The graph is copied to the selected folder.

1. Access the graph for which you want to specify or modify the data source.
2. In the left pane, select Data Source.

   The Data Source workspace appears.

   

3. Next to the Query Path or the Dataset Path box, select .

   The Select a query, or a dataset from the catalog window appears.

   

4. In the left pane, navigate to the folder that contains the query or the dataset that you want to use as the data source.
5. Select the query or the dataset, and then in the lower-right corner of the window, select Open.
   Note: If the query that you have selected contains a prompt, then a window appears, displaying the prompt. Provide the required values, and then select Done.

   The Query Path or the Dataset Path box is populated with the folder path of the query or the dataset that you selected.

   If you have selected a query, then the results of the query appear in the workspace.

   -or-

   If you have selected a dataset, then the values in the dataset appear in the workspace.

   Important: The changes are saved only after you specify the graph dimensions, and then select .

1. Access the graph for which you want to modify the graph type.
2. In the left pane, select Graph Type.

   The Graph Type workspace appears.

3. Select the type of graph that you want to use. The bar graph is selected by default.

   For example, if you want to change the graph type to a pie graph, select .

4. In the upper-right corner of the page, select .

   The graph type is changed.

1. Access the graph for which you want to specify the graph dimensions.
2. In the left pane, select Dimension Mapping.

   The Dimension Mapping workspace appears.

   

   Note: If you are mapping the dimensions for a heat map or color scale graph, you will be mapping columns instead of a series.
3. In the Vertical Axis Values section, select Map Series.

   The Dimension for Series window appears.

   Note: If you are creating a color scale graph, the Vertical Axis Value must be taken from the query column that returns the name of the color displayed on the color scale. The logic for determining the color for each row of query results should be embedded in the query itself using any valid HTML color name or code. For example, the following query determines colors based upon the value of another column:

   SELECT [MC_MTCRD].[MC_MTCRD_TIME_STAMP_D] "Timestamp" 
   , Decode([MC_MTCRD].[MC_MTCRD_VALUE_C], 'RUNNING', Green', 'INFEEDHOLD', 'Yellow', 'DOWNLOADING', 'Yellow', 'ABORTED', 'Red', 'Orange') "Color" 
   FROM [MC_MTCRD] ORDER BY [MC_MTCRD].[MC_MTCRD_TIME_STAMP_D] Asc 

4. Select the dimensions that you want to plot on the vertical axis, and then select Apply.

   The selected dimensions appear in the Vertical Axis Values section.

5. In the Category section, select Map Category.
   The Dimension for Category window appears.

   Note: If you are creating a time series graph, the Dimension for Category must be time stamp.
6. Select the category that you want to plot on the x-axis, and then select Apply.

   The selected dimension appears in the Category section.

7. Select .
8. If you have created a new graph, in the Save As window that appears, in the pane, navigate to the catalog folder in which you want to save the graph, provide the details of the graph, and then select Save.

   -or-

   If you have accessed an existing graph, in the window displaying confirmation that the graph is saved. Select OK.

   The changes made to the graph dimensions are saved.

   Note: For pie charts, you can localize the labels on the slices from a system code table or a family state machine. You can do so using the options that are available in the Category section of the Dimension Mapping workspace.

   If you selected a system code table and the value in the Category section matches a code in the specified system code table, the localized description value from the table will be used to display the label. Similarly, if you selected a family for which state management is enabled and the value in the Category section matches a state ID in the specified state machine, the localized state caption will be used to display the label.

1. Access the graph whose query or dataset you want to access.
2. In the upper-left corner of the Graph Result workspace, select .

   The query or dataset appears.

1. Access the graph that you want to refresh.
2. In the upper-left corner of the Graph Result workspace, select .

   The graph refreshes to display the most recent information.

1. Access the graph for which you want to add a hyperlink.
2. In the upper-right corner of the workspace, select .

   The Settings pane appears.

3. Select the Series tab.

   The Series section appears.

4. In the Pick an axis box, select the axis to which you want to apply a hyperlink.
5. In the Hyperlink box, select the hyperlink that you want to add to the axis that you have selected.

   The hyperlink is added to the graph.

1. Access the graph for which you want to specify the limits for vertical axis values.
2. In the upper-right corner of the workspace, select .

   The Settings pane appears.

3. Select the Axis tab.

   The Axis section appears.

4. Provide the minimum and maximum values in the Minimum and Maximum boxes respectively.

   The graph refreshes to plot only those values that fall in the limits that you have specified.

1. Access the graph for which you want to specify the format for vertical axis values.
2. In the upper-right corner of the workspace, select .

   The Settings pane appears.

3. Select the Axis tab.

   The Axis section appears.

4. In the Format box, select the format for the vertical axis values.

   The graph is refreshed to plot the vertical axis values in the specified format.

1. Access the graph for which you want to specify the number of decimals for the vertical axis values.
2. In the upper-right corner of the workspace, select .

   The Settings pane appears.

3. Select the Axis tab.

   The Axis section appears.

4. In the Decimals box, select the number of decimals for the vertical axis values.
   Note: If the value in the Format field is None, then the vertical axis values do not contain decimals.

   The graph is refreshed to plot the vertical axis values with the specified number of decimals.

1. Access the graph for which you want to specify the number of decimals for the vertical axis values.
2. In the upper-right corner of the workspace, select .

   The Settings pane appears.

3. In the Graphs section, select the 3D check box.

   The graph is refreshed to display in a three-dimensional view.

   Tip: If you want to covert the graph to a two-dimensional view, clear the 3D check box.

1. Access the graph for which you want to show or hide the legend.
2. In the workspace, select .
   The Settings pane appears.
3. To view the legend at a specified location or hide the legend, follow these steps:
   1. To specify the location for the legend, in the Legend drop-down list box, select a location.
      The graph is refreshed, and the legend appears at the selected location.
   2. To hide the legend, in the Legend drop-down list box, select Hide Legend.
      The graph is refreshed, and the legend is hidden.

      Note: For pie charts, you can position the legend only at the top of the Graph Result workspace.

1. Access the graph for which you want to show or hide the grid lines.
2. In the upper-right corner of the workspace, select .

   The Settings pane appears.

3. Select the Axis tab.

   The Axis section appears.

4. If you want to show the grid lines, select the Grid Lines check box.

   The graph is refreshed to display the grid lines.

5. If you want to hide the grid lines, clear the Grid Lines check box.

   The graph is refreshed to hide the grid lines.

1. Access the graph for which you want to enable or disable the logarithmic scale.
2. In the upper-right corner of the workspace, select .

   The Settings pane appears.

3. Select the Axis tab.

   The Axis section appears.

4. If you want to enable the logarithmic scale, select the Logarithmic check box.

   The graph is refreshed to reflect the logarithmic scale.

5. If you want to disable the logarithmic scale, clear the Logarithmic check box.

   The graph is reverted to its original scaling.

Example

For example, the following image shows a graph whose values on the scale are displayed using the Number format option when the Logarithmic box is cleared.

If you were to select the Logarithmic box, the same graph would appear as shown in the following image.

1. Access the graph for which you want to show or hide labels.
2. In the upper-right corner of the workspace, select .

   The Settings pane appears.

3. If you want to view the vertical axis labels, in the Graphs section, select the Show Labels check box.

   The graph is refreshed to show the vertical axis labels.

4. If you want to view the x-axis labels, in the Graphs section, select the Show X-Axis Labels check box.

   The graph is refreshed to show the x-axis labels.

5. If you want to hide the vertical axis labels or the x-axis labels, clear the Show Labels or Show X-Axis Labels check box, respectively.

   The graph is refreshed to hide the labels.

1. Access the graph for which you want to show or hide the scroll bar.
2. In the upper-right corner of the workspace, select .

   The Settings pane appears.

3. If you want to view the scroll bar, in the Graph section, select the Show Scroll Bar check box.

   The Maximum amount of points to show box appears.

4. In the Maximum amount of points to show box, enter the number of points that you want to view per page.

   The graph is refreshed to show the specified number of points per page. You can use the scroll bar to view the rest of the pages.

5. If you do not want the scroll bar, in the Graphs section, clear the Show Scroll Bar check box.

   The graph is refreshed to show all the points on a single page.

1. Access the graph for which you want to show full-length labels.
2. In the upper-right corner of the workspace, select .

   The Settings pane appears.

3. In the Graph section, clear the Truncate Labels check box.

   You can now see the full-length graph label.

1. Access the Catalog page for the folder containing the graph whose properties you want to modify.
2. In the row for the graph whose properties you want to modify, select .

   The Catalog Item Properties window appears, displaying the properties for the selected graph.

   

3. As needed, modify values in About Catalog Items window, and then select Done.

   The properties for the selected graph are modified.

1. Access the graph for which you want to modify the colors.
2. In the upper-right corner of the workspace, select .

   The Settings pane appears.

3. Select the Series tab.

   The Series section appears.

   

4. In the Color box, select the color that you want to apply.
   Tip: If the color that you want to apply is not available, select More, select the color, and then select Choose.

   The selected color is applied to the series that you have specified in the Pick a series to edit box.

1. Access the Prompt Settings section of the query that is used to generate the graph.
   Note: For more information on the Prompt Settings section, refer the Queries module documentation.
2. Create any of the following prompts for the query:
   • Create a Prompt with No List of Valid Values
   • Create a Prompt with a Static List of Valid Values
   • Create a Prompt with a List of System Codes
   • Create a Prompt with a List of Query Results
   • Create a Prompt with a List of Values from a Record
   • Create a Prompt on a Logical Field

   The prompt is created for the query. When you access the graph, the prompt appears.

   Note: For more information on creating a prompt, refer the Query Expressions, Clauses, and Prompts section, in the Queries module documentation.

You can export a graph to a PDF document.

1. In the module navigation menu, select Tools > Graphs.
   The Graphs page appears.
2. Select Browse, and then select a graph from the catalog.
3. Select Open.
   The selected graph appears in the Graph Result workspace.
4. Select .
   The Print window appears.
5. Select Save as PDF as the destination, and then select Save.
   The Save As window appears.
6. Select a location for the file and enter a file name, and then select Save.
   The graph is saved as a PDF document to the selected location on your local drive.

1. Access the Catalog page, for the folder that contains the graph that you want to delete.
   Note: For more information on the Catalog page, refer the Catalog module documentation.
2. Select the check box that corresponds to the graph that you want to delete.
3. In the upper-right corner of the page, select .

   A confirmation message appears, asking if you really want to delete the graph.

4. Select OK.

   The graph is deleted.