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.
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.
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.
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. |
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.