#3156: Export Milestone to CSV
--------------------------------+-------------------------------------------
Reporter: anonymous | Owner: daniel
Type: enhancement | Status: reopened
Priority: normal | Milestone:
Component: roadmap | Version: 0.9.4
Severity: normal | Resolution:
Keywords: convert export csv |
--------------------------------+-------------------------------------------
Comment (by anonymous):
mgood, a report with all ticket changes would work as long as it is
exportable. In short mgood, my plan is to use the csv output in
conjunction with pivot tables to find relationships between diff projects.
The pivot table allows for dynamic analysis of the data. Each team will
evaluate the data for point we can improve on the next time around.
The stats that we are going to look for first are as follows:
{{{
1. Open, Close, Verify Count: # of tickets opened and closed by each
member of the team
2. Ticket Iteration Ratio: number of times a ticket was reopened by QA
after it was closed per developer. (max, min, avg)
3. Priority Ratio: What is the ticket priority distribution per dev.
4. Priority Delta: How does the priority distribution / dev change over
the course of the milestone fulfillment?
5. Severity Ratio: What is the severity distribution per dev?
6. Severity Delta: How does the severity distribution / dev change over
the course of the milestone fulfillment?
7. Duplicate ticket total and per team member count (reporter and closer)
8. Invalid ticket total and per team member count (reporter and closer)
9. Wontfix ticket total and per team member count (reporter and closer)
10. Worksforme ticket total and per team member count (reporter and
closer)
11. Max, Min, Avg ticket lifetime: length of time it took to close
tickets. (Final close only)
12. Total Punt Count: number of tickets that were a part of the milestone
but were pushed to a later release
13. Component count: total number of tickets logged against any component
14. Total Ticket logged count: total number of tickets logged for a
milestone
15. Total Ticket closed count: total number of tickets that were closed
against a milestone
'''Note:''' Punt Count = total ticket logged - total ticket close
}}
--
Ticket URL: <http://projects.edgewall.com/trac/ticket/3156>
The Trac Project <http://trac.edgewall.com/>
_______________________________________________
Trac-Tickets mailing list
[email protected]
http://lists.edgewall.com/mailman/listinfo/trac-tickets
