Additional Options for Duration and Trend Reports

Additional Options

  • Show Labels in Local Time

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

  • Use Logarithmic Scale (Graphs only)

    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.

  • Optional HTML Template

    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.

  • Add Columns of Calculations

    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.
    Tip: For Date/Time fields, click the Date/Time Keywords link to select a Date/Time keyword, such as Now or Startof_NextWeek, for your calculation.
    Important: Certain calculations are not possible, such as multiplying, dividing or adding dates or Date/Time Keywords. Invalid calculations will result in an error when you run the report. The errors may prevent the report from running at all, resulting in the following message:
    An error occurred while processing the last request.
    
    The error was:
    
    Database exception in ....
  • Show Whole Rows and Columns of Zero (0)

    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

    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.

    You can set a high threshold, a low threshold, or both. Thresholds cannot be used with percentile stacked bar charts or pie charts. The following threshold options are available:
    • Set High Threshold Greater Than – Type a number that indicates a high threshold when the report data is greater than that number. For a report that tracks the number of items submitted by particular users, you may want to set a high threshold that indicates when over 75 items have been submitted.

    • Set Low Threshold Less Than – Type a number that indicates a low threshold when the report data is lower than that number. For a report that tracks the number of items submitted by particular users, you may want to set a low threshold that indicates when fewer than 10 items have been submitted.

    • Using Color – Click the Color link for each threshold to open the Select Color dialog box and select a color for each threshold. You must select a color if you set a high or low threshold. The color for each threshold appears in the background of the report.

Related Topics

Time In State Reports

Backlog Trend Reports

Entering a State Trend Reports

Open and Completed Trend Reports

State Activity Reports