Interacting with Charts

When you have opened a chart, you can dynamically interact with it to change the way you display your data. The following section describes how chart data can be viewed and manipulated in Netcool Reporter.

Moving and Resizing a Chart

To rotate the chart, click one of the edges of the chart, and while holding down the mouse button, move the chart outline until it is in the position you require.

To resize your chart, click a corner of the chart, and while holding down the mouse button, drag the outline until it is the size you require.

To move your chart, click anywhere within the chart, and while holding down the left mouse button, drag the outline to the position you require.

To restore your default viewpoint, double-click the chart background.

2D Charts

Figure 49 shows a bar chart of products with two dimensions (City and Age Category), and two measures (Sum of Costs and Average Profit).

 

   Figure 49: Sample 2D Chart

The Age Category dimension appears along the X-axis, and the measures appear as successive bars for each age category. The legend for the dimension of City appears at the top of the chart. Below the City legend is the name of the particular city on display.

You can scroll through all the cities using the drop-down list next to the city name (Atlanta).

Swapping Dimensions

You can swap dimensions by clicking a data dimension (displayed along the top of a chart) and dragging it over one of the measure dimensions. For example, in the chart shown above, If you click and drag the City legend and drop it in place of the Age Category legend, the city names appear along the X-axis.

Creating Split Scales

You may want to view the two measures using two different scales. For example, might require the cost or the products and the average profit on the same chart.

To create split scales for all types of charts:

1.   Shift-click the measure button for which you want to create a new scale. You see a black box to the right of the button, along the right edge of the chart.

2.   Drag the button to the black box. A second scale is displayed along the right side of the chart. The following chart shows a different scale on the right for average profit.

 

   Figure 50: Split Scales

Another way to create split scales for line charts is to:

1.   Right-click the measure legend for which you want to create a new scale.

2.   Select Set Formatting from the pop-up menu. This displays the Format Chart Measure window.

3.   Choose Secondary Axis.

4.   Click OK.

You may apply the secondary scale to another line by repeating these steps for that line.

3D Charts

Figure 51 shows an example of a 3D chart. There are two dimensions Age Category and City; and two measures Sum of Costs and Average Profit. Because this is a 3D chart, you can see both dimensions at once, one on the X-axis and the other on the Z-axis.

 

   Figure 51: Sample 3D Chart

In a 3D chart, you can swap dimensions and create dual scales in the same way as a 2D chart. For more information, see 2D Charts on page 104.

The Chart Button Bar

The chart button bar for charts differs slightly depending on whether you are viewing your charts in two or three dimensions.

 

   Figure 52: Chart Button Bar

Table 27: Description of the Chart Button Bar

Button

Option

Description

 

Save

Saves the chart descriptor file with all of the properties you set. You can reuse this descriptor file with other charts you create in the future.

 

Export

Exports the presentation to one of a number of different formats.

 

Visualization Type

Opens the visualization button bar, as described inThe Visualization Type Button Bar on page 108.

 

Chart Type

Changes the chart types, as described in Creating a Chart on page 192.

 

Tree View

Sets the tree indentation view, as described in Tree View Buttons on page 109.

 

Drill Mode

Selects drill up or drill down mode, as described in Drilling Through a Chart on page 110.

 

Toggle Expand/Collapse Drill

Toggles between expand-collapse drilling and replace drilling, as described in Drilling Through a Chart on page 110.

 

Drill-Through

This is a special option that must be enabled by the designer of your presentation. Drilling through data lets you see what information the data is based on. If the designer enables drill-through, then when you double-click the chart, Netcool Reporter launches a browser window containing the HTML address your administrator chose.

 

Back/Forward View

Move back and forward through recent revisions of your chart.

 

Visual Customize

Adjust the format of the chart or table, as described in Customizing Charts on page 278.

 

Data Customize

This button is not used and is disabled.

 

Sort Value Ascending

This sort option must be applied using the Sort button.

 

Sort Value Descending

This sort option must be applied using the Sort button.

 

Sort

Sorts the data in the chart or table, as described in Sorting Charts and Tables on page 109.

 

Hints

Displays hints at the bottom of the browser window as you move your cursor over different parts of the chart.

 

Help

Displays the online version of this guide.

The Visualization Type Button Bar

The Visualization Type button opens the visualization button bar, as shown below.

 

   Figure 53: Visualization Button Bar

The buttons allow you to view a chart as a 2D chart, 3D chart, or pivot table. From left to right the options are:

For descriptions of the 2D, 3D charts and pivot tables, see Creating a Chart on page 192.

Tree View Buttons

You can set the indent for the tables using the buttons described in the following table.

Table 28: Table Indentation Styles

Button

Option

Description

 

No indentation

All row labels are flush left.

 

Reverse-tree indentation

Rows are indented according to their place in the tree structure, with children listed above the parents.

 

Tree indentation

Rows are indented according to their place in the tree structure, with children listed below their parents.

Sorting Charts and Tables

To sort the chart or table currently being displayed:

1.   Select the Sort Value Ascending button then click the Sort button. The Sort Ascending window is displayed, as shown below.

 

   Figure 54: Sort Ascending Window

2.   Select the measure or display dimension on which to sort from the drop-down list.

3.   Select the Value radio button to arrange in ascending order the numerical values/quantities pertaining to segments.

4.   Select the Label radio button to arrange in ascending alphabetical or numeric order the labels for the selected measure.

To sort the values or labels in descending alphabetical or numeric order, select the Sort Value Descending button and repeat the process.

If you (or the presentation designer) have chosen a default sort order for that dimension, the elements appear in that order. If not, the elements appear in the same order they appear in the source data. This is useful if there is one natural order for the elements, and the data already reflects that order. For example, if the elements are the months of the year, the data most likely lists the elements in chronological order. Alphabetical order, in this case, is less useful.

Drilling Through a Chart

You can move through the levels of detail in a drill-down chart by drilling down or up. When you drill down on data, you increase the level of detail. When you drill up on data, you see the next most general piece of data.

Click the Drill Mode button to open the drill direction button bar, as shown below.

 

   Figure 55: Drill Direction Button Bar

For example, if you click the Drill Down button on Q1 2002 sales figures, you might be shown the sales figures for January, February, and March 2002. When you click the Drill Up button on the Q1 2002 sales figures, the sales figures for each year in the 2000s might appear.

To drill down in a drill-down chart, double-click the element you want to see in more detail. To drill up in a drill-down chart, click the Drill-Up icon and click the chart.

You can drill in two different ways: replace and expand-collapse. Toggle between the two options with the Toggle Expand/Collapse Drill button.

If this button is selected, the presentation uses expand-collapse drilling. If it is deselected, the presentation uses replace drilling.

Replace Drilling

If you have selected replace drilling, after every drill-down or drill-up operation, all the members displayed are at the same level in the hierarchy and all have the same parent node.

When you drill down by double-clicking any element (with the Drill-Down button selected), then the chart or table displays all the children of that element and no other elements. The element you double-clicked is no longer shown.

When you drill up by double-clicking any element (with the Drill-Up button selected), the chart displays the parent of the element you selected, the siblings of that parent, and no other nodes. The element you double-clicked is no longer shown.

Expand-Collapse Drilling

Expand-collapse drilling lets you see several layers of the hierarchy at once.

When you drill down by double-clicking any element (with the Drill-Down button selected), the children of the element you clicked appear in the chart or table. All the elements that were shown before you performed the drill-down are still displayed.

When you drill up by double-clicking any element (with the Drill-Up button selected), the parent of that node is collapsed. That is, the parent of the node you clicked is displayed in the chart or table, but all of its descendants are removed from the chart or table (including the element you clicked).

Saving a Chart Descriptor

The chart descriptor contains the chart appearance settings you have defined using the Customization window. For details of the Customization windows for pivot tables, 2D charts and 3D charts, see Chapter 6: Customizing Reports on page 247.

Click the Save icon to save the chart descriptor file. The Save Descriptor window is displayed, as shown below.

 

   Figure 56: Save Descriptor Window

Enter a name for the descriptor file without a file extension and click OK.

The chart descriptors can be applied to other charts using the 2D Chart Descriptor and 3D Chart Descriptor drop-down list in the Chart Properties window. For details of the Chart Properties window, see Chart Properties on page 267.

Exporting a Chart

You can use the Export button to export the chart descriptor, the chart image, or the chart data to a file. When you click the Export button the Export window is displayed, as shown below.

 

   Figure 57: Export Window

Select one of the following options from the Save as type drop-down list:

The options available in the drop-down list depend on the type of chart that is currently displayed.

Exporting a Report as a GIF File

The GIF option saves the chart as a snapshot image. When you select GIF and click OK the image is opened in a new browser window. To save this file, use your browsers Save File option.

Exporting a Table to a Spreadsheet

To export a table to Microsoft Excel or another spreadsheet application:

1. Before running Netcool Reporter, configure your web browser to associate CSV files with your preferred spreadsheet application.

2. In the Netcool Reporter output, click anywhere on the table you want to export and display.

3. Click the Export icon in the button bar.

4. Choose the desired output format:

5. Choose CSV for generic spreadsheet data. The format is plain-text file with comma-  separated values.

6. Click OK or press Enter.

   Note:


    Only the data actually displayed in the Netcool Reporter chart or table is exported. This means that the exported table has one value for each of the page dimensions and up to five values for the measure dimensions, even if those dimensions have more members in the actual database.


Exporting a Chart or Table to PDF

To export a chart or a table to a portable document format (PDF) file:

1.   Make sure your browser is configured to launch an appropriate PDF reader program (such as Adobe Acrobat reader).

2.   In the Netcool Reporter output, click anywhere on the chart or table you want to export and display.

3.   Click the Export icon in the button bar.

4.   Choose PDF as the format.

5.   If you wish, enter text to be printed at the bottom of every page. The code &p prints the page number and &d prints the date the file was generated.

6.   Select the Portrait Mode option to generate an output that is taller than it is wide. Deselect to generate a landscape output.

7.   Click OK or press Enter.

8.   Your browser launches a new window displaying the chart or table in PDF format. To save this file, use your browsers Save File option.

 

   Note:


    Page dimensions are not displayed in PDF format. In addition, x axis data can be lost. Check the print preview, and use smaller column widths or smaller fonts if any x axis data does not appear.


Exporting Pivot Tables to HTML

To export a pivot table chart as an HTML file:

1.   Click anywhere on the table you wish to export and display.

2.   Click the Export icon in the button bar.

3.   Choose HTML as the format.

4.   If you want to customize the HTML output, enter the name of a parameter file in the text box.

5.   Click OK or press Enter.

6.   A new browser window is displayed showing the table as an HTML table.

Printing Charts and Pivot Tables

To print a chart:

1.   First export the chart to GIF, as described in Exporting a Report as a GIF File on page 112.

2.   A new browser window is displayed with the chart shown in GIF format.

3.   Click Print in the new browser window.

To print a pivot table:

1.   First export the pivot table to HTML, as described in Exporting Pivot Tables to HTML on page 114.

2.   After a moment, a new browser window is displayed with the table shown as an HTML table.

3.   Click Print in the new browser window.

Customizing a Chart

Click the Customize icon to customize a chart. For information on the Customization window, see Customizing Charts on page 278.