Create Chart Dialog

The Create Chart wizard helps you to create a chart in a report. It appears when you select Insert > Chart, or drag a chart type from the Components panel into a report.

The wizard varies with the data resource type used to create the chart: business view or query resource.

Back

Goes back to the previous screen.

Next

Goes to the next screen.

Finish

Finishes creating the table and closes this dialog.

Cancel

Does not retain changes and closes this dialog.

Help

Displays the help document about this feature.

Create Chart - Business View Based

When the wizard is used for creating a chart using a business view, it consists of the following screens: Data, Type, Display, Filter, Layout and Style.

Data

The screen lists all the predefined business views in the current catalog. Select the one using which to create the chart.

Create Chart - Data

Inherit from the Parent

Specifies to inherit data from the business view used by the parent object. Available only when the chart is to be inserted into any of the following panels in a banded object in a web report: banded header panel, banded footer panel, group header panel and group footer panel.

Type

Specifies the type of the chart. You can refer to the section Chart Types which describes each of the chart type in detail. When using business view as the chart data source, only the 2-D chart types are supported.

Create Chart - Type

Single chart

Specifies to create a single chart.

Chart Type
Lists all the chart types that can be used to create a single chart.
Subtype
Lists all the subtypes of the selected chart type. Hover the mouse pointer on a subtype icon and you will see its name.

Combo chart

Specifies to make more than one type use the primary or secondary axis. The types should be featured as Combination charts. Two types of data markers are used to represent different data values.

Chart Type
Lists all the chart types that can be added as a combo chart.
Subtype
Lists all the subtypes of the selected chart type. Hover the mouse pointer on a subtype icon and you will see its name.

Chart Type Groups
Lists all the chart types that are to be used in the combo chart.
- Primary Axis
  - <Add Combo Type>
    Adds a chart type to the primary axis.
- Secondary Axis
  - <Add Combo Type>
    Adds a chart type to the secondary axis.
Removes the selected chart type from the Chart Type Groups box.

Display

Specifies the data to display on the chart. This screen differs according to the chart type: common chart types, organization chart or heat map.

For common chart types

Create Chart - Display

Title

Specifies the title of the chart.

Resources

Lists the resources in and related to the specified business view, which can be used to create the chart.

Add button

Adds the selected field in the Resources box to the chart axis.

Remove button

Removes the selected field from the chart.

Category/Series box

Lists the field to display on the category/series axis of the chart. For a gauge chart, you can select the Advanced button to show or hide the Category/Series box.

For a real time chart, if no category field is specified, the text Use System Refresh Time will be automatically displayed in the Category box, namely the time at which the chart refreshes itself will be used as the category value; the series axis will be disabled.

Special Group
Opens the User Defined Group dialog to define how to group information.
Order/Select N
Opens the Category Options dialog or Series Options dialog to specify the sort order of the category or series values and define the number of the category or series values to show on the chart.

Show Value box

Lists the values you want to show in the chart.

Opens the Edit Additional Value dialog to edit an additional value. Available only when a constant value or an average value is selected.
Moves the selected value one step up.
Moves the selected value one step down.
Adds a new pair of Y-Axis and Size for the bubble chart.
Removes the selected value from the bubble chart.
X-Axis
Lists the value you want to show on the X axis of the bubble chart.
Y-Axis
Lists the value you want to show on the Y axis of the bubble chart.
Size
Lists the value you want to show as the bubble size.

Motion Bar for Playable Chart

Lists the field used as the motion field. A motion field can only be of the Integer, Date or Time data type. Available to single bar, bench and bubble charts in web reports and library components only.

Special Function
Opens the Special Function dialog to define special function to the motion field. Available only when the motion field is of the Date data type.

Real Time

Specifies to run the chart in real time mode. Available to single bar, bench, line, and area charts in web reports and library components only.

Use System Time for Category
Specifies to use the time at which the chart refreshes itself as the category value.
Refresh Interval
Specifies the time interval at which the chart will get data and refresh itself automatically.
Show Most Recent N Points
Specifies the number of points that will be kept for the real time data on the chart.
Incremental Fetch
Opens the Unique Key dialog to configure a unique key for the real time chart.

For organization chart

Create Chart - Org Display

Node

Specifies the field the values of which to display as the nodes in the org chart.

Parent

Specifies the field which shows the "reporting to" relationship among the node field values.

Resources

Lists the resources in and related to the specified business view, which can be added to display in each node in the org chart. You can also add images and labels to the nodes.

Properties

The Properties box presents a node model for specifying the information you want to display in each node in the org chart.

For heat map

Create Chart - Heat Map Display

Resources

Lists the resources in and related to the specified business view, which can be used to create the heat map.

Area

Lists the groups of the heat map. There should be at least one group.

Moves the selected group one step up.
Moves the selected group one step down.
Color By
Specifies whether to color by a group.
Label By
Specifies whether to show the values of a group in the innermost rectangles.
Special Group
Opens the User Defined Group dialog to define how to group information.
Order/Select N
Opens the Group Options dialog to specify the sort order of the group values and define the number of the group values to display in the heat map.

Property

Lists the aggregations added to calculate data based on the lowest group of the heat map.

Size By
Specifies to use the aggregation to determine the size of the rectangles.
Color By
Specifies to use the aggregation to determine the fill color of the rectangles.
Label By
Specifies whether to show the values of an aggregation in the innermost rectangles.

Filter

Specifies to filter data displayed in the chart. The options in the screen are the same as those in the Edit Filter dialog.

Create Chart - Filter

Layout

Specifies the layout of the chart elements. Some layout options may not be available for certain chart types. For details about the options, go here.

Create Chart - Layout

Style

Specifies the style of the chart.

Create Chart - Style

Style

Specifies the style of the chart.

Preview

Displays the selected style and layout effects.

Inherit Style

Specifies whether to make the chart take the style of its parent. This options is available only when the chart is to be inserted in a banded object in a page report.

Create Chart - Query Based

When the wizard is used for creating a chart using a query resource, it consists of the following screens: Data, Type, Display, Filter, Layout and Style.

Data

Specifies the dataset using which to create the chart.

Create Chart - Data

Data resource box

Lists the predefined data resources in the current catalog. Select one and a dataset based on it is created automatically for the chart.

More Options/Less Options

Shows or hides the dataset selection panel to choose a dataset for the chart.

New Dataset
Specifies to create a dataset from the current catalog data resources. When a query is selected, you can select the Edit button to edit the query in the Query Editor.
Existing Dataset
Specifies to use a dataset from the ones existing in the current page report. You can select the Edit button to edit the dataset in the Dataset Editor.
Current Dataset
Specifies to inherit the dataset used by the parent object.

Type

Specifies the type of the chart. You can refer to the section Chart Types which describes each of the chart type in detail.

Create Chart - Type

Single chart

Specifies to create a single chart.

Chart Type
Lists all the chart types that can be used to create a single chart.
Subtype box
Lists all the subtypes of the selected chart type.

Combo chart

Specifies to make more than one type use the primary or secondary axis. The types should be featured as Combination charts. Two types of data markers are used to represent different data values.

Chart Type
Lists all the chart types that can be added as a combo chart.
Subtype box
Lists all the subtypes of the selected chart type.

Chart Type Groups
Lists all the chart types that are to be used in the combo chart.
- Primary Axis
  - <Add Combo Type>
    Adds a chart type to the primary axis.
- Secondary Axis
  - <Add Combo Type>
    Adds a chart type to the secondary axis.
Removes the selected chart type from the Chart Type Groups box.