Reporting → Using Custom Reports → Report Reference → Trend Reports → 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.
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:
In the Column box, type the name that will appear as the Column Header in the report.
In the first calculation box, select a field that will serve as the first operator from the drop-down list.
Submit Date = (now Minus 30)
Should be specified as (without the parentheses):
Submit Date = now Minus 30
In the second calculation box, select a field that will serve as the second operator from the drop-down list.
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.
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.
Copyright © 2013–2015 Serena Software, Inc. All rights reserved.