[rt-users] RT Reporting - We need your wishlists

[Emmanuel Lacour]

On Thu, Feb 14, 2008 at 09:52:52AM -0500, Jesse Vincent wrote:
> Hi Everybody,
> 
> I have an RT hacker working on a new, expanded reporting tool for RT.  
> While I can't promise that we'll implement _every_ report you want, we  
> could really use your wishlists.
> 
> What reporting and statistics do you want to get out of RT?


here is a list of things we made here (some already exists with current
Reports module in 3.6.x):

(many charts use our 'Customer' customfield value for grouping)

- Count of open tickets for the current month grouped by CF "customer"
- Count of open tickets for the current month for a named value of CF "customer",
  grouped by CreatedDaily
- Count of Tickets unresolved since at least 1 month grouped by CF
  "customer"
- Count of Tickets unresolved since at least 1 month for a named value
  of CF "customer", grouped by CreatedDaily
- Count of Tickets unresolved since at least 1 week grouped by CF
  "customer"
- Count of Tickets unresolved since at least 1 week for a named value of
  CF "customer", grouped by CreatedDaily
- Count of Tickets, grouped by CF "responsability"
- TimeWorked sum for current month tickets, grouped by CF "customer"


Charts wanted which we didn't did (need to much work):

- Average time to resolve tickets grouped by CF "customer"
- Ticket count grouped by Priority and CF "responsability"


Mostly, the current lack on Reports module is to easily charts times
(some like TimeWorked can be done by Modifying Search/Chart and
Search/Elements/Chart (tip: s/COUNT/SUM/ ;)), but creating reports with
a difference between for example OpenDate and ResolveDate seems more
difficult).


It would be nice also to have a link for downloading the generated datas
as csv on the Chart page.


Hope this can help making a powerfull RT reporting tool :)).