Additional Options for Duration and Trend Reports

Select this check box if you want column labels to display times using your local time zone. 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.

This drop-down list contains HTML templates for customizing the look of your report. Provided templates include excellist.htm, which improves the display of Listing report results when they are exported (by right-clicking the report output and then selecting Export to Microsoft Excel), and massselectlist.htm, which provides buttons at the top of the page, enabling you to select or clear the check boxes for all items in the results list. Your administrator can customize report templates, and the templates in the list may or may not apply to the type of report you are creating. Select the template from the drop-down list.

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.

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.