Configuring Graph Types

Use the Graph binding dialog to map data from an ADF data control onto the DVT Graph.  The following information is available to help you with this process:

Overview:  Binding Graphs to ADF Data Controls
Examples:  Graph Type Configurations

Overview:  Binding Graphs to ADF Data Controls

The Graph binding is a data-mapping layer between the ADF Graph data visualization component and an ADF data control.   To set up this mapping, the Graph binding dialog is used.  This document shows how to use the Graph binding dialog to configure the data for different Graph types.

Graph types, such as bar, pie, scatter, etc. have different data requirements.  The Graph binding dialog has been designed to allow for a wide range of mappings between the data as sourced from a data control and all of the various Graph type specific data models.

The Graph binding dialog is comprised of the following elements:

Graph binding dialog
The basic steps used to fill out this dialog are:
1.    Specify the numeric facts or metrics you want to graph in the “Data Points” section of the dialog.
2.    Specify the data attributes to show on the axis or legend of the graph in the “Group By” section of the dialog.
3.    Optionally, specify additional data categories over which the numeric data points will be categorized in the “Data Points” section of the dialog.
4.    Use the Preview tab to see what the Graph will look like when bound to the data as specified in steps 1-3 above.

Examples: Graph Type Configurations

Refer to the following examples for details on how to fill out the Graph binding dialog for the various types of Graphs:


Simple Graph Types
Bar, Line, Area Example 1: Setting up Bar, Line, & Area Graphs
Combo Example 2: Setting up Combo Graphs
Pie Example 3: Setting up Pie Graphs <to be written>
Complex Graph Types
Bubble Example 4: Setting up Bubble Graphs
Scatter Example 5: Setting up Scatter Graphs
Stock Example 6: Setting up Stock Graphs

Example 1: Setting up Bar, Line, & Area Graphs

Bar Graphs, Line Graphs, and Area Graphs all have similar data models and are configured using the Graph binding dialog the same way.

A. Single numeric fact


Bar Graph 1

Graph binding dialog settings



Bar Graph 1 binding dialog

  • In the Data Points section, the numeric data attribute ‘Sal’ is specified, along with a label of ‘Salary’, which is displayed in the legend of the Graph.  The salary data in this case is coming from a typed data attribute of the data control, so the default setting of Typed Attributes is used.
  • In the Group By section, employee name (‘Ename’) is specified.  The names are displayed as axis labels, as indicated by the Display Group Values setting.

B. Multiple numeric facts


Bar graph 2

Graph binding dialog settings



Bar Graph 2 binding dialog


  • The numeric columns being graphed are all specified in the Data Points section of the Graph binding dialog.  Since the data is coming from separate data attributes of the data control, using Typed Attributes is appropriate.
  • The employee name column is specified in the Group By section of the dialog.  The names will appear as labels on the ordinal axis of the stacked bar graph.
  • Setting Display Group Values to In Legend will cause the Graph to display the employee names in the legend and the numeric facts to be displayed on the ordinal axis:
Bar graph 2A

Example 2: Setting up Combo Graphs


Combo graph 1

Graph binding dialog settings



Combo graph 1 binding dialog


  • The order of the facts in the Data Points section of the dialog is significant.  The first data attribute will be assigned to the first data marker shape (Sales to bar markers in this case), the second data attribute will be assigned to the second data marker shape (Cost to line markers in this case), etc.  Selecting a row and pressing the blue arrow icons re-orders the data attributes.

Example 4: Setting up Bubble Graphs


Bubble graph 1

Graph binding dialog settings



Bubble graph 1 binding dialog


  • For bubble graphs, there must be at least 3 numeric data attributes specified in the Data Points section of the dialog.
  • The order of the numeric data attributes specified in the Data Points section of the dialog maps to the X axis, Y axis, and bubble size, respectively.  In this example, GNP is the first metric listed in the Data Points section, so it is plotted along the X axis of the Graph, Life Expectancy is second metric and is plotted along the Y axis, and Population is listed third and determines the size of the bubble.
  • The Group By section the dialog is used to determine what should appear in the legend of the bubble chart.  Therefore, the Display Group Values should be set to In Legend.  In this example, the Region attribute is used to provide legend entries.
  • Country is listed as a data category before the numeric data attributes.  The bubble graph binding interprets this to mean that each country in the data set will have three numeric data attributes (GNP, Life Expectancy, and Population) and each country will be shown with its own bubble marker.

Example 5: Setting up Scatter Graphs




Scatter graph 1

Graph binding dialog settings



Scatter graph 1 binding dialog


  • For scatter graphs, there must be at least 2 numeric data attributes specified in the Data Points section of the dialog.
  • The order of the numeric data attributes specified in the Data Points section of the dialog maps to the X axis, and Y axis, respectively.  In this example, GNP is the first metric listed in the Data Points section, so it is plotted along the X axis of the Graph;  Life Expectancy is listed second and is plotted along the Y axis.
  • The Group By section the dialog is used to determine what should appear in the legend of the scatter graph.  Therefore, the Display Group Values should be set to In Legend.  In this example, the Region attribute is used to provide legend entries.
  • Country is listed as a data category before the numeric data attributes.  The scatter graph binding interprets this to mean that each country in the data set will have two numeric data attributes (GNP and Life Expectancy) and each country will be shown with its own marker.

Example 6: Setting up Stock Graphs




Mapping data from multiple data attributes


Stock graph 1

Graph binding dialog settings



Stock graph 1 binding dialog


  • In this example, the data control provides a separate data column for each required data attribute (open, high, low, etc.).  Therefore the default setting of Typed Attributes is used.
  • For all stock graphs, the order of the attributes listed in the Data Points section of the dialog must be Open, High, Low, Close, Volume.  If the stock graph type in use only requires a subset of these attributes, specify them in this order.
  • The market date attribute is specified in the Data Points section of the dialog as a Data Category.
  • The stock symbol attribute is set in the Group By section, and since stock symbol (ORCL in this example) is constant across dates, Display Group Values is set to In Legend.  (Note:  Stock graphs, in the current release, are intended to show data for only one stock at a time.  As a result, some stock graph types, such as the one in this example, will not display a legend.  A Graph title can be used to displayed the stock name if desired.)

Mapping data from a single data attribute



Stock graph 2 table of data



Stock graph 2 binding dialog


  • Make sure the Name-Value Pairs option is selected.  “Name” in Name-Value Pairs refers to the attribute that has the metric names.  “Value” in Name-Value Pairs refers to the attribute that has the metric values.
  • Provide the “Name” attribute in the Value Type Attribute dropdown [we should probably rename this dropdown control to “Name Attribute”], and the “Value” attribute in the Value Attribute dropdown.  In this example, these are the ‘Measure’ and ‘Data’ attributes, respectively.
  • Add the same items to the Data Points section of the dialog as in the previous example.  Make sure that the Data Attributes specified match the metric names in the data (e.g. OPEN, HIGH, LOW, etc.)
false ,,,,,,,,,,,,,,,