[[PageOutline(2-5,Contents,pullout)]]

{{{
#!NewsFlash
'''Status'''

The plugin is undergoing 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).
 * May not work with MySQL and PostgreSQL (#8703).
}}}

= Plot Trac Ticket Statistics

== Description

This plugin visualizes Trac ticket statistics. It plots the number of open tickets, the number of new tickets and the number of tickets closed over a time period. It correctly accounts for tickets being reopened and closed during the reporting period, ie by not including them in the total.

The plugin includes a macro that allows a TracQuery to be used as an arguments.

This plugin requires:
 * [http://developer.yahoo.com/yui/charts YUI Charts] is used to render the graph.
 * Adobe Flash player needs to be installed on the client.

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's arguments are:
 * '''title''': caption to your graph
 * '''height''': graph height, default 500 px.
 * '''column_width''': default 40 px.
 * '''daterange''': date range specified as "from;to" or just "to". Using Trac's 0.12 date field query syntax (trac:wiki:TracQuery?version=20#QueryLanguage).
 * '''res_days''': resolution in days for each point in the graph.

Version 2.1 of this plugin looks as follows:

[[Image(screenshot01.png, 80%)]]

See also TicketChartsMacro, TracMetrixPlugin, TracGvizPlugin.

== Bugs/Feature Requests

Existing bugs and feature requests for TracTicketStatsPlugin are 
[report:9?COMPONENT=TracTicketStatsPlugin here].

If you have any issues, create a 
[/newticket?component=TracTicketStatsPlugin new ticket].

[[TicketQuery(component=TracTicketStatsPlugin&group=type,format=progress)]]

== Download

Download the zipped source from [export:tracticketstatsplugin here].

== Source

You can check out TracTicketStatsPlugin from [/svn/tracticketstatsplugin here] using Subversion, or [source:tracticketstatsplugin browse the source] with Trac.

== Installation

General instructions on installing Trac plugins can be found on the [TracPlugins#InstallingaTracplugin TracPlugins] page.

Add '''ticketstats.* = enabled''' to the [components] section of your `trac.ini` file:
{{{#!ini
[components]
ticketstats.* = enabled
}}}

== Configuration

The following options can be specified in `trac.ini` (default values are shown):
{{{#!ini
[ticketstats]
yui_base_url = http://yui.yahooapis.com/2.9.0      # Location of YUI API
}}}

== Recent Changes

[[ChangeLog(tracticketstatsplugin, 3)]]

== Author/Contributors

'''Author:''' [wiki:echo0101] [[BR]]
'''Maintainer:''' [[Maintainer]] [[BR]]
'''Contributors:''' mixedpuppy (#3900), simon (#3921)