[[PageOutline(2-5,Contents,pullout)]] {{{ #!NewsFlash '''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). '''Priority Enhancements''' '''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 == [[Image(http://trac-hacks.org/attachment/wiki/TracTicketStatsPlugin/screenshot01.png?format=raw,50%)]] [[br]] Screenshot of v2.1 on our dev server. == Bugs/Feature Requests == Existing bugs and feature requests for TracTicketStatsPlugin are [report:9?COMPONENT=TracTicketStatsPlugin here]. If you have any issues, create a [http://trac-hacks.org/newticket?component=TracTicketStatsPlugin&owner=rjollos 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): {{{ #!ini [ticketstats] yui_base_url = http://yui.yahooapis.com/2.9.0 # Location of YUI API }}} == Download == Download the zipped source from [download:tracticketstatsplugin here].[[BR]] == Source == You can check out TracTicketStatsPlugin from [http://trac-hacks.org/svn/tracticketstatsplugin here] using Subversion, or [source:tracticketstatsplugin browse the source] with Trac. == Other Technologies Used == * [http://developer.yahoo.com/yui/charts 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')]] }}} [[Image(wiki:TicketStatsMacro:severalGraphs.png, 50%)]] 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 == [[ChangeLog(tracticketstatsplugin, 3)]] == Author/Contributors == '''Author:''' [wiki:echo0101] [[BR]] '''Maintainer:''' rjollos [[BR]] '''Contributors:''' mixedpuppy (#3900), simon (#3921)