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

[13110] by rjollos on 05/13/13 11:02:04

Refs #8140: Tag version 2.2.0 of TracTicketStatsPlugin.

[13109] by rjollos on 05/13/13 10:56:55

Create a tags dir.

[13108] by rjollos on 05/13/13 09:19:18

Refs #8140:

• Changed macro option name from ticketstatsmacro to ticketstats.
• Moved macro template to an external file. When only Trac 0.12 and later is supported, and add_script_data is available, the template can be transformed to a JS script.

[13107] by rjollos on 05/13/13 09:18:43

Refs #8703, #7001: Optimize SQL queries and properly utilize the Trac database API to prevent SQL injection and improve cross-DB compatibility.

Author/Contributors

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