Creating a Chart View

The following steps describe how to create a chart view:

1. Open a new view, enter a Name, and select Chart from the View Type drop-down list.

• Notice that the tab layout is updated automatically: a new Chart tab appears in the dialog and the Fields, Format, Hierarchy, and Paging tabs are removed.
• Note that not all of the tabs shown in figure may be available on your system, depending on how your administrator configured the Chart View type's -properties.
• If you want to use an existing template as the starting point for your view, click the Load Template... button. See Loading a View Template for details.
• Note that the Show Default Preview Pane is only applicable to list views.

Chart View Type

1. Click the Chart tab.
2. Select a Chart Type. See Chart View Types for information on the supported chart types.

Select a Chart Type

1. Click the Grouping tab and specify how the view should organize record data in the chart.

• See Configuring Grouping Properties for instructions.
• You must define the grouping characteristics to successfully create a chart view.

1. Click the Summary tab and specify what function the chart should use to summarize the data.

• See Configuring Summary SQL Operation for instructions.
• The default summary operation is a Count of record IDs in each group.

1. Click the Display tab and configure the legend and grid lines that appear on the chart.

• See Formatting Chart View Display for instructions.
• If you accept the default settings, the chart displays all major grid lines for each of its axes. No legend is displayed.

1. Click the Color tab and configure the color scheme for the chart.

• See Formatting Chart View Color for instructions.
• If you accept the default settings, the chart background is white and chart elements are randomly assigned colors.

1. Click the Title tab and add one to four titles to the chart.

• See Specifying Chart Title for instructions.

1. Click the Data Options tab and configure the chart's labels and other data settings.

• See Specifying Chart Data Options for instructions.

1. Click the Axis Scaling tab to specify a scale for the chart's axes (if applicable).

• See Specifying Axis Scaling for instructions.
• If you accept the default settings, charts that include axes use smart scaling.

1. Click the Filters tab to specify filter criteria for the view. See Defining View Filters for instructions on creating filter statements.
2. Click the Auto Refresh tab to configure how often the view should automatically refresh. See Enabling Auto Refresh for details.
3. If you want this view to run automatically on a pre-determined schedule (for example, to send out a report periodically to a defined recipient list), click the Scheduling tab and configure the available options. See Scheduling a View to Run Automaticallyfor details.
4. If you want to modify the SQL statement that defines the chart view, click the Advanced (SQL) tab and edit the SQL statement as needed. See "Advanced SQL Option" on page 241 for details.
5. Click OK to load the view.