Download ANALYTICS MANUAL

Adding comparison columns to reports
257
Figure 132: Comparison Match Columns Window
4 Select the column(s) that define the corresponding values. For example, to keep the number of incidents assigned to the same staff member on the same row, select the Assigned
Account column.
5 Move the selected column to the Comparison Match Columns panel by dragging the field
or clicking the right arrow.
6 Click the OK button to save the change to the comparison options.
Adding comparison percentage columns
Once you add a comparison value column to a report for a numeric field, you can then add a
Comparison Percentage computed field column to the report. This column returns the percentage difference between the comparison value column and the column being compared.
For example, if a value in the compared column is 10, and the corresponding comparison
value is 15, the percentage difference would be 50%.
To add a comparison percentage column to a report:
1 Add a comparison value column to the report, as described in “Adding comparison columns to reports” on page 255.
2 Expand the Computed Fields tree in the data dictionary.
Tip
You can also add comparison percentage columns by clicking the comparison
column you added on the design surface, clicking the Design tab, clicking the
arrow on the Insert Column button, and selecting Comparison % Change.
3 Click the comparison value column you added.