Chart Axes and Measures Selection

This section describes the process of populating the columns and measures in a chart. To create a chart using the selected universe, click the Chart Mode button on the Layout tab. The Selected Items field displays the crosstab layout structure, as shown below.

 

   Figure 226: Chart Layout Structure

Within the chart you can set between one and seven items as horizontal chart axes. Within the report you must define between one and 50 measures. Each measure adds a value to each column, based on the data in the column. Measures can be added using functions including sum and count.

Easy Reporter can create both two-dimensional (2D) and three-dimensional (3D) charts. For 2D charts, items you wish to measure should be placed along the horizontal axis. For 3D charts, the first item you place along the horizontal axis is plotted on the horizontal (x-) axis. The second is plotted on the z-axis. Measures are plotted along the vertical (y-) axis.

Selecting Axes

To place an item along the horizontal axis of a chart:

1.   Expand the universe, as described in Universe Selection and Navigation on page 347.

2.   Click and drag the item from the Select Folder and Items: field to the Selected Items: field and drop the item over the area labelled Drag items here to define horizontal axis.

Selecting Measures

To make an item a measure in a chart:

1.   Expand the universe, as described in Universe Selection and Navigation on page 347.

2.   Click and drag the item from the Select Folder and Items: field to the Selected Items: field and drop the item over the area labelled Drag items here to define measures.

3.   If the item you drag contains a numeric value, the measure defaults to Sum. If it contains a non-numeric values, the measure defaults to Count.

Changing the Measure Type

After dragging a numeric value to the measures field you can change the measure type. To change the type right-click the measure and select Summary Function from the drop-down list.

Select a function from the Summary Function drop-down list. The functions are listed in the following table.

Table 72: Summary Functions Description

Summary Function

Description

Sum

Adds together the numeric values of each item in the column.

Count

Counts the number of items in the column.

Count Distinct

Counts the number of items in the column ignoring duplicates.

Maximum

Returns the value of the highest value item in the column.

Minimum

Returns the value of the lowest value item in the column.

Average

Returns the average value of all items in the column.

Removing Items

To remove an item from the Selected Items: field, select one of the following:

•   Click and drag the item out of the Selected Items: field.

•   Right-click the item and select Delete from the pop-up menu.

•   Click the item and press the Delete key.