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 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:
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.
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.
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–2016 Serena Software, Inc. All rights reserved.