Time Reports
Time reports show trends over time. Use Time reports to answer questions like: "What is the issue arrival rate?", or "How fast are issues being resolved?"
Defining the Time Axis
The time axis divides the reporting period into intervals of days, weeks, months, quarters, or years (this is the granularity of the report). The Time report then sorts the issues into the time intervals, and counts the number of issues in each interval.
To sort issues into time intervals, a Time report uses a master date. The master date is a specified in an issue field such as Submitted Date, Closed Date, Assigned Date, or Update Date.
Master Date |
Description |
Assigned Date |
The date an issue was assigned. For a report that shows the number of open issues per analyst or developer, you could use the Assigned Date instead of the Submitted Date. |
Closed Date |
The date an issue was closed. This happens when Progress is set to a value that maps to the Closed state. Use this date for reports that show the number of issues fixed over time (fix rate reports). |
Submitted Date |
The date an issue was submitted. Use this date for Time reports that show the number of submitted, open, or closed issues over time. |
Update Date |
The date an issue was last modified. |
Including All Dates
Select the Show dates with no values check box to show days, weeks, months, quarters, and years when there were no issues. For example, in a report that shows the daily arrival rate of new issues during the last week, you probably want to see a value for each day in the week, even if that value is 0.
Showing Interval Totals
When the Cumulative check box is selected, a Time report accumulates the number of issues from one interval to the next. For example, suppose you have a Time report that shows the number of submitted issues per week. To see how the total number of submitted issues grows week by week, select the Cumulative check box. To see the number of issues submitted each week, clear the Cumulative check box.
Defining Reporting Periods
Enter specific From and To dates, or choose one of the When conditions: This Month, This Quarter, or This Year. You can also combine From or To with When. For example, if the year is 2006 and you set From to 3/3/06 and When to This Year, your reporting period would be 3/3/06 to 12/31/06.
Including Totals
Select the Total check box. For each time interval, the Time report shows the total number of issues included in the report.
Controlling Column Width in Tabular Time Reports
Use the Column Width box to set a maximum width for all columns in a report, including the column headings.
Defining the Field Axis
The field axis determines which issues a report counts. For example, to include the number of ASAP and Today priority issues, choose these Priority field values as the columns. The Time report then counts the number of ASAP and Today priority issues in each interval.
Each column corresponds to a possible value of a choice-list field (single or multi). For example, you can add columns for all possible priority values, or just for the highest priorities (ASAP, Next 4 Hours, Today).
Text (cross-tab) reports
Each column is a column in the cross-tab table.
Line charts
Each column is a line in the line chart.
Bar charts
The column specifies what bars to display for each row.
If you set Field Name to <None>, then the Time report provides a total of all issues for each interval.
Related Topics