Creating a Chart

When you select Chart mode, the tab layout in your working space changes. The Table, Column, Joins, Conditions, and Order By tabs are identical to the tabs in Report mode. Data you have entered in these tabs is kept as you change to Chart mode. The operation of these tabs is described in Chapter 4: Getting Started with Report Designer on page 119.

To configure your chart, select the Chart tab, as shown below. Unlike tabular reports, your choice of chart format does not influence the way you select the columns to be displayed. Any chart type can be chosen for any chart format. The only requirement is a minimum of two axes for a 2D chart and three axes for a 3D chart. For both types of chart there must be at least one entry in each Axis: list and one entry in the Measures: list.

 

   Figure 111: Chart Page

Chart Basics

Report Designer can create both two-dimensional and three-dimensional charts. A two-dimensional (2D) chart has a horizontal axis (the X-axis) that displays the values for the data dimension, and a vertical axis (the Y-axis) that displays the values for the selected measure column.

 

   Figure 112: 2-Dimensional Chart

For example, if you wanted to chart your expenses over time, you would place time along the X-axis, and the dollar value of expenditures (the measure) along the Y-axis.

Three-dimensional charts have in addition a third axis (the Z-axis) that shows a second data axis in the depth of the chart.

 

   Figure 113: 3-Dimensional Chart

For example, if you want to take the expenditure chart in the example above, and expand it to include expenditures for each department. You can place your time data along the X-axis and your expenditure measure along the Y-axis, but break down your expenditures by department in the Z-axis.

The actual values that are displayed on the chart are called measures. You can use up to fifteen columns as measures. Because the measure values to be charted must be numeric, Report Designer lists only columns with numeric data in the Available Measure Columns: list. When you use the Chart page, the measures you enter from the Available Measure Columns: list appear on the Y-axis, and those columns you select from the Available Axis Columns: list appear on the X and Z axes.

Choosing a 2D Chart Type

This section describes each of the 2D chart types available on the Chart Properties window. The example charts are all based on the single chart configuration entered in Figure 111 Chart Page on page 192. The chart type property has been changed to show the types of chart available. The date and chart header are not shown.

To select a 2D chart, click the Properties button on the Chart tab. The Chart Properties window is displayed, as shown below. Table 33 identifies the chart types buttons.

 

   Figure 114: Chart Properties Window: 2D Chart Types

Table 33: 2D Chart Types

No.

Chart Type

Description

1

2D Scatter Chart

See 2D Scatter Chart on page 195.

2

2D Pie Chart

See 2D Pie Chart on page 196.

3

2D Line Chart

See 2D Line Chart on page 196.

4

2D Area Chart

See 2D Area Chart on page 197.

5

2D Bar Chart

See 2D Bar Chart on page 197.

6

2D Box Chart

See 2D Box Chart on page 198.

7

2D Stacked Bar Chart

See 2D Stacked Bar Chart on page 198.

8

2D Grid Chart

See 2D Grid Chart on page 199.

9

Pivot Table

See Pivot Table on page 199.

Select 2D from the Chart Style drop-down list then select one of the nine types on the tab. An example of each chart type is shown in the following sections.

The Output drop-down list and the General tab are described in Chapter 6: Customizing Reports on page 247.

2D Scatter Chart

The 2D Scatter chart shows patterns in the relationships among different variables. Each datapoint is represented as a single dot. A positive correlation (for example, when rising overheads correlate with rising total costs) typically results in a concentration of points forming a line moving up and to the right.

A negative correlation (for example, when rising costs negatively correlate with rising profits) typically results in a concentration of points moving down to the left. Unrelated variables produce a randomly scattered pattern over the field.

An example 2D Scatter chart is shown below.

 

   Figure 115: Example 2D Scatter Chart

2D Pie Chart

The 2D Pie chart shows the relationship between each item and the whole. For example, you can show what percentage of your annual expenditures go to marketing, payroll, and other departments.

An example 2D Pie chart is shown below.

 

   Figure 116: Example 2D Pie Chart

2D Line Chart

The 2D Line chart shows progressions through time. They are often used to maintain a record of expenses and forecast future trends. In addition, line charts are useful for determining relationships. For example, a peak in marketing expenses one quarter may be followed by a peak in production costs the next, reflecting increased demand for a product.

An example 2D Line chart is shown below.

 

   Figure 117: Example 2D Line Chart

2D Area Chart

The 2D Area chart shows a line chart with the area underneath the line shaded. This has the effect of emphasizing the amount of change in a value over the rate of change in the value. Also, an area chart can stack the values of your variables above one another, resulting in an emphasis on the largest sum at any given time rather than the peaks and valleys of individual data columns.

An example 2D Area chart is shown below.

 

   Figure 118: Example 2D Area Chart

2D Bar Chart

The 2D Bar chart is the default chart type for most displays. Bar charts are commonly used for their simplicity, and easily highlight the relative values of different data points.

An example 2D Bar chart is shown below.

 

   Figure 119: Example 2D Bar Chart

2D Box Chart

The 2D Box chart is similar to a bar chart, except that values are arranged along a baseline value, shown as the X-axis. A box chart is primarily used for showing positive and negative values, such as the degree of profit/loss in a given year.

An example 2D Box chart is shown below.

 

   Figure 120: Example 2D Box Chart

2D Stacked Bar Chart

The 2D Stacked Bar chart stacks each category of data on top of the other categories, so that the topmost level for a division represents the total for that division. For example, this chart can be used to compare the budgets of different departments within each division.

An example 2D Stacked Bar chart is shown below.

 

   Figure 121: Example 2D Stacked Bar Chart

2D Grid Chart

The 2D Grid chart shows each data element in its own cell. You can use this chart to emphasize before-and-after results, or sharply divide negative from positive data values.

 

   Figure 122: Example 2D Grid Chart

Pivot Table

The Pivot Table shows your data in a simple pivot table format. You may select which axes to view from a drop-down list in the chart. An example Pivot table is shown below.

 

   Figure 123: Example Pivot Table

Choosing a 3D Chart Type

This section describes each of the 3D chart types available on the Chart Properties window. The example charts are all based on the single chart configuration entered in Figure 111 Chart Page on page 192. The chart type property has been changed to show the types of chart available. The date and chart header are not shown.

To select a 3D chart, click the Properties button on the Chart tab. The Chart Properties window is displayed, as shown below. Table 34 identifies the chart types buttons.

 

   Figure 124: Chart Properties Window: 3D Chart Types

Table 34: 3D Chart Types

No.

Chart Type

Description

1

3D Area Chart

See 3D Area Chart on page 201.

2

3D Scatter Chart

See 3D Scatter Chart on page 201.

3

3D Pie Chart

See 3D Pie Chart on page 202.

4

3D Line Chart

See 3D Line Chart on page 202.

5

3D Contour Chart

See 3D Contour Chart on page 203.

6

3D Bar Chart

See 3D Bar Chart on page 203.

7

3D Box Chart

See 3D Box Chart on page 204.

8

3D Stacked Bar Chart

See 3D Stacked Bar Chart on page 204.

9

Pivot Table

See Pivot Table on page 205.

Select 3D from the Chart Style drop-down list then select one of the nine types on the tab. An example of each chart style is shown in the following sections. The Output drop-down list and the General tab are described in Chapter 6: Customizing Reports on page 247.

3D Area Chart

The 3D Area chart shows a line chart with the area underneath the line shaded. This has the effect of emphasizing the amount of change in a value over the rate of change in the value. An area chart can stack the values of your variables above one another, resulting in an emphasis on the largest sum at any given time rather than the peaks and valleys of individual data columns. Be careful that one area does not obscure the area displayed behind it in a 3D display.

 

   Figure 125: Example 3D Area Chart

3D Scatter Chart

The 3D Scatter chart shows patterns in the relationships among different variables. Each datapoint is represented as a single dot. A positive correlation (for example, rising overheads correlated with rising total costs) typically results in a concentration of points forming a line moving up and to the right. A negative correlation (for example, rising costs negatively correlated with rising profits) typically results in a concentration of points moving down to the left. Unrelated variables produce a randomly scattered pattern over the field.

 

   Figure 126: Example 3D Scatter Chart

3D Pie Chart

The 3D Pie chart shows the relationship between each item and the whole. For example, you can show what percentage of your annual expenditures go to marketing, payroll, and other departments. The third dimension lets you look at several charts simultaneously. You may, for example, look at a series of pie charts, each giving the budget breakdown from a single department.

 

   Figure 127: Example 3D Pie Chart

3D Line Chart

The 3D Line chart shows progressions through time, and is often used to maintain a record of expenses and forecast future trends. In addition, line charts are useful for determining relationships. For example, a peak in marketing expenses one quarter may be followed by a peak in production costs the next, reflecting increased demand for a product. Be careful that one line does not obscure the line displayed behind it in a 3D display.

 

   Figure 128: Example 3D Line Chart

3D Contour Chart

The 3D Contour chart shows a filled-in three-dimensional representation of data, represented as X-, Y-, and Z-coordinates. Contour charts are particularly good for portraying topographic data.

 

   Figure 129: Example 3D Contour Chart

3D Bar Chart

The 3D Bar chart is the default chart type for most displays. Bar charts are commonly used for their simplicity, and easily highlight the relative values of different data points. The third dimension lets you look at several charts simultaneously. You may, for example, look at a series of bar charts, each giving the budget breakdown from a single department. In addition, it is easier to notice trends across departments in a 3D bar chart, as some values may be significantly higher than others in your chart.

 

   Figure 130: Example 3D Bar Chart

3D Box Chart

The 3D Box chart is similar to a bar chart, except that values are arranged along a baseline value, shown as the X-axis. A box chart is primarily used for showing positive and negative values. For example, the chart can show the degree of profit/loss within each division in a given year.

 

   Figure 131: Example 3D Box Chart

3D Stacked Bar Chart

The 3D Stacked Bar chart stacks each category of data on top of other categories, so that the topmost level for a division represents the total for that division. For example, this chart can be used to compare the budgets of different departments, or for a combined report from several divisions over a period of time (such as the four quarters of a year).

 

   Figure 132: Example 3D Stacked Bar Chart

Pivot Table

The Pivot Table shows your data in a simple pivot table format. You can select which axes to view from a drop-down list in the chart. The Table button on the 3D chart selection tab is identical to the Table button on the 2D chart selection tab. For a description of the pivot table chart style, see Pivot Table on page 199.

Choosing a Combo Chart Type

This section describes the combination chart types available on the Chart Properties window. The example charts are all based on the single chart configuration in Figure 111 Chart Page on page 192. The chart type property has been changed to show the types of chart available. The date and chart header are not shown.

To select a combo chart, click the Properties button on the Chart tab. The Chart Properties window is displayed, as shown below.

 

   Figure 133: Chart Properties Window

A combo chart lets you select a different display type for each measure. For example, you may display salaries in a bar chart format, length of time worked in a line chart format, and so forth. All are displayed together. Select the measure you want to change in the Measures: list and use the Chart Type for Measure: drop-down list to select the type of display in which you want to show the measure. Click OK to finish. Note that you must attach a descriptor file (.ch2) to the chart in order to generate GIF images.

 

   Note:


    The Show Chart as gif image checkbox is disabled for Combo charts. This limitation does not allow you to save a combo chart as gif image from within the Report Designer. If you wish to do so, export the combo chart as a gif image and save it in your browser window. For information on exporting charts, see Exporting a Chart on page 112.


Entering Chart Axes and Measures

The Available Axis Columns: list lists the columns selected on the Columns tab that you can use as axes in your chart. To use a column as a chart axis, highlight the column name by clicking it in the list and then click the Add button. It then appears in the Axes: list on the right. You can also double-click the name to add it to the Axes: list. Click the Remove button to remove the highlighted column from the Axes: list.

The first axis you choose becomes the first data dimension of the chart and is initially displayed on the horizontal or X-axis. The measure dimension is used as the Y-axis. If you are displaying a 3-D chart, the second column you add to the Axes: list is displayed on the Z dimension that extends along the depth of the chart. All other dimensions are listed as legends along the top of the screen. You can swap those dimensions with the displayed ones to change the information displayed by the chart.

The Available Measure Columns: list shows the available columns containing numeric data that you can use as measures in your chart. Select the column name by clicking it, and then click the Add button.

You may not select an aggregate function as an axis of the chart. If you do so, an error is displayed when you run or preview the chart.

 

   Note:


    You can select up to 7 data dimensions and 15 measures. For very large charts, this may be limited by your browser memory. See Chart Creation and Client Browser Memory on page 209.


Changing Measure Heading Names

You can change the measure headings that appear in a chart by selecting the measure name in the Measures: list, and entering a new name in the Measure Heading: field. This is helpful if measure names are too long or cryptic. The headings you enter here affect only the chart and are independent of the tabular and break reports.

Adding a Chart Title

To display a title at the top of the chart, enter the title in the Chart Title: field.

If you create a parameterized chart file, you can add the parameter in the chart title. Add the exact parameter name as you typed it on the Conditions tab, with an ampersand (&) before it. When the chart is run with specific parameter values, these values are substituted in place of the parameter name in the chart title.

You can add more than one parameter in the title, including those that take multiple values.

Choosing a Summary Type

When you are defining a chart you can summarize data into groups that share common values. Select the summary type from the Summary Types: drop-down list. The summary types are described in the following table.

Table 35: Summary Types

Summary Type

Description

sum

Calculates the total value. This is the default setting.

avg

Calculates the average value.

count

Calculates the number of values.

count distinct

Calculates the number of unique values. Duplicate values are not counted more than once.

min

Displays the highest value.

max

Displays the lowest value.

For more information on these summary types, refer to your database documentation.

Setting Chart Properties

The Properties button on the Chart tab displays the Chart Properties window. This window allows you to customize the chart.

On the Chart Type tab of the Chart Properties window, you can select the following types of chart:

•   2D Charts - See Choosing a 2D Chart Type on page 194

•   3D Charts - See Choosing a 3D Chart Type on page 199

•   Combination Charts - See Choosing a Combo Chart Type on page 205

For details of other chart properties, see Chart Properties on page 267.

Creating a Custom Call

The Custom Call feature allows external actions to be triggered upon report creation. Click the Custom Call button on the Chart tab to display the Custom Call window.

For a description of the Custom Call feature, see Creating a Custom Call on page 242.

Previewing Charts

Once you have defined your chart, you can preview it. To preview your chart as an interactive chart, click the Preview button. A Start Generating Report message appears in the bottom left corner of the Chart page. When the chart data has been returned from the database a new browser window is opened on top of the Report Designer, the Charts applet is launched in the new window, and, after a few moments, the chart appears.

If you do not see your chart in a new window, but the Chart snapshot generated message appears in the lower left corner of the Chart page, check your web browser to see if another window is already open with the chart. Once you have created a new window to display a chart, Report Designer places all new charts in that same window as long as it is open. If you want to have Report Designer create a new window and bring it up over the Report Designer each time you preview a new chart, you should close the window with a chart each time after you are finished previewing it.

An example chart is shown below.

 

   Figure 134: Charts Interface

Chart Creation and Client Browser Memory

Charts that are created using Report Designer have the complete data set embedded within the HTML page that you are viewing. These are Java applets that allow the chart to be flexible and interactive at the client level (where you do not have to be connected to the server).

When you create a chart with more than a few axes as columns, it is possible to exceed the maximum HTML page size or loading time of your web browser. Web browsers have limits on how much data they can load as a single HTML page. The larger the page, the more memory is required. There could also be problems when data embedded into the HTML page is parsed into the chart’s applet memory.

If you are creating a very large chart, you may want to create a cube or drill chart using Report Designer instead. These load portions of the data dynamically from the Netcool Reporter server.

There is a formula you can use to predict the size of the HTML page that contains a chart and its data. The size of the HTML file generated by Report Designer depends upon the product of the number of rows of the tables for each of the specified columns multiplied by 10, plus the size of the applet itself, and the space needed to load the data.

For example, if you select two columns, where the first column is in a table of 2000 rows, and the second column in a table with 100 rows, then the HTML file size is approximately 2000 * 100 * 10, which is 2 MB. You also need about 2 MB for the applet and space to load the data. This combined total is approximately 4 MB for a single page. If you are experiencing problems with the chart at the client end, then you should reduce the number of columns and/or rows being reported against or use a cube or drill chart instead.

Interacting with Charts

In Report Designer, you can dynamically interact with your chart to experiment with ways of displaying your data. After you have found a display format you like, you may choose to save your chart and use it later in a presentation (see Interacting with Charts on page 210).

Saving a Chart Snapshot

If you want to see the chart again using the same data that is now displayed, you need to save the chart in HTML format. HTML is the standard format for representing the pages you see in a web browser. To save the chart, click the Save Snapshot button and enter the name of the file. When naming your file:

•   Do not include a file extension (no text after a period).

•   Do not include any spaces in the file name.

•   Do not include any special characters (@,#,$,%) in the file name.

•   Do not enter very long file names.

To view the chart snapshot, click the file in your Inbox.

Saving a Chart Definition

If you want to be able to redraw the chart you have designed at a later date using the same query to retrieve updated data, you must save the chart definition. Click the Save Definition button and enter the name of the file.

To recreate the chart in the future by running the query again, select the menu option File ΖOpen, and select the chart definition.