Additional Options for Duration and Trend Reports

Select this check box if you want column labels to display times and calculate time intervals in the time zone selected in the user profile for the user running the report. Clear the check box if you want labels to show times in Universal Coordinated Time (UTC).

Select this check box to apply a logarithmic scale to your report. You may want to do this to reduce your report results to a manageable range if they cover a large range of values. This option only applies to certain report styles, such as line, scatter, and bar charts.

Choose custom colors for values shown in graphical reports. Values are based on the row and column fields you selected on the Content tab. Depending on the report style, color may be applied to row values, column values, or both. If you do not select colors, random colors are used.

Choose custom colors for values for the Group By field you selected on the Content tab. If you do not select colors, random colors are used.

You can include calculations on Numeric, Binary/Trinary, and Date/Time fields in your report results. The calculations available are addition, subtraction, multiplication and division. For details, refer to Calculations in Listing and Multi-Table Reports.

To add a calculation to a report:

1. In the Column box, type the name that will appear as the Column Header in the report.

2. In the first calculation box, select a field that will serve as the first operator from the drop-down list.

3. Select an operand from the next list.

   Note: Date fields can only be subtracted. Multiplying, dividing, and adding date fields will yield an error.

   Note: For any calculation you create that begins with a Date/Time keyword (like now or startof_thisweek), you must ensure that the keyword is the first token in the expression. For example, the following expression:

   Submit Date = (now Minus 30)

   Should be specified as (without the parentheses):

   Submit Date = now Minus 30

4. In the second calculation box, select a field that will serve as the second operator from the drop-down list.

5. Click Add New Calculation to add another calculation, if desired.

An error occurred while processing the last request.

The error was:

Database exception in ....

By default, Distribution reports do not show rows that have only zeros as values. Select this check box to show the rows that only have zeros as values.

Some display labels are skipped if a large number of values is returned on the horizontal axis. Select this check box to show all labels. If the labels are difficult to read, clear this check box to show fewer labels. This option does not apply to tabular reports.

Select this check box to show the number of items returned for each row on the graphical report. If a large number of values are returned, they may be difficult to read. You can clear this check box to show fewer values. To see values, hover your mouse over a bar or pie segment to view the number of items returned. This option does not apply to tabular reports.

Select this check box to easily show or hide the data points for tape, line, and area charts. This option is always enabled for scatter charts. You can use this option in combination with Show Chart Values to view data points and values simultaneously.

Thresholds allow you to apply visual indicators to your report that inform you when data rises above or falls below numbers you specify. Apply a color to each threshold that appears in the background of the report.