Status

The plugin is undergoing rapid development and is subject to frequent change leading up to the next stable release (3.0.0). Please report back if you are able to test out the latest version.

Known (Confirmed) Issues

• There are issues that make this plugin appears to not work in certain cases. The issues are thought to be related to poor handling of the start and end dates (see #3412, #8296, #8330).
• Does not work with PostgreSQL (#3899).

News

• 2013-05-12: TicketStatsMacro has been merged with the TracTicketStatsPlugin (#8140).

Trac Ticket Statistics

Description

TracTicketStatsPlugin visualizes Trac ticket statistics. It plots the number of open tickets, the number of new tickets and the number of tickets closed. The plugin includes a macro that allows t:TracQuery's to be used as arguments.

See also TicketChartsMacro, TracMetrixPlugin.

Screenshots

Screenshot of v2.1 on our dev server.

Bugs/Feature Requests

Existing bugs and feature requests for TracTicketStatsPlugin are here.

If you have any issues, create a new ticket.

Installation

Don't forget to add ticketstats.* = enabled to the [components] section of trac.ini.

The following options can be specified in trac.ini (default values are shown):

[ticketstats]
yui_base_url = http://yui.yahooapis.com/2.9.0      # Location of YUI API

Download

Download the zipped source from here.

Source

You can check out TracTicketStatsPlugin from here using Subversion, or browse the source with Trac.

Other Technologies Used

• YUI Charts is used to render the graph.
• Adobe flash player needs to be installed on the client.

Example

This plugin can be used to visualize the progress of a project by seeing the rate of tickets being created vs. tickets being closed. Graphs can be customized.

The macro allows graphs to be inserted within wiki markup.

[[TicketStats(title = Total tickets last 15 days, height=250,daterange=15d,res_days=1)]]

[[TicketStats(title = Error tickets by week last 3 months, daterange=3m,res_days=7, query=Type='error')]]

The macro arguments are:

• height: graph height, default 500 px.
• column_width: default 40 px.
• res_days: resolution (in days) for each point in the graph.
• title
• daterange: date range specified as "from;to" or just "to". Using 0.12's date field query sintax (http://trac.edgewall.org/wiki/TracQuery?version=20#QueryLanguage)

Recent Changes

[13197] by rjollos on 05/22/13 08:55:07

Refs #8140: Added requirement of TracAdvParseArgsPlugin since the code integrated from the TicketStatsMacro requires it. However, this dependency might be eliminated later on.

[13192] by rjollos on 05/21/13 09:23:01

Fixes #7540: Added a datepicker for the start and end date. The datepicker will only be available in Trac 1.0 and later, in which jQuery UI is distributed with Trac.

The feature could be made available in earlier versions of Trac by including jQuery UI directly (see for example how this is done in /backlogplugin/trunk/backlog/web_ui.py?rev=12796), but I won't bother with this unless someone asks for it.

[13191] by rjollos on 05/21/13 06:29:57

Refactoring:

• Don't pass db argument to Milestone.select. The parameter is deprecated.
• Better Genshi code for generating the milestone options list.
• Only show the YUI debug logger if the debug parameter is passed.

[13190] by rjollos on 05/21/13 06:29:42

Fixes #8300: URI encode the static URL. Call index method of list to get index of item. Previously the non-existent find method was being called.

Author/Contributors

Author: echo0101
Maintainer: rjollos
Contributors: mixedpuppy (#3900), simon (#3921)