Custom reports

RT Users
1

Hello,

I need to create a custom report, showing the number of tickets for
certain type (a custom field of the RT), in a determined period.
I tried the RTx-Statistics, but was not useful.

This would be possible?

Thanks!

2

Fernando Fugita wrote:

Hello,

I need to create a custom report, showing the number of tickets for
certain type (a custom field of the RT), in a determined period.
I tried the RTx-Statistics, but was not useful.

You really have to write it yourself. Attached is a report that we use
at Carnegie Mellon - Qatar.

WorkByClassification.tgz (1.88 KB)

3

All,

I implemented the attached report generator, and it works great with one exception.
I would like to be able to see which tickets do not have a value in that custom field. Meaning, the page shows a count of how many tickets have value x, and value y in that custom field, I would like an additional count of how many have not set something in that custom field and after a few hours, I still cant figure out how to do it so I thought I would ask. I have reattched the file for convienience.

Thanks,
JeffFrom: Brian Gallew geek+rt@cmu.edu
To: RT-Users@lists.bestpractical.com
Sent: Wednesday, September 12, 2007 6:42:48 AM
Subject: Re: [rt-users] Custom reports

Fernando Fugita wrote:

Hello,

I need to create a custom report, showing the number of tickets for
certain type (a custom field of the RT), in a determined period.
I tried the RTx-Statistics, but was not useful.

You really have to write it yourself. Attached is a report that we use
at Carnegie Mellon - Qatar.

Catch up on fall’s hot new shows on Yahoo! TV. Watch previews, get listings, and more!
http://tv.yahoo.com/collections/3658

WorkByClassification.tgz (1.88 KB)

4

Thank you, I will try the solutions.

Regards,
Fernando.

Sean wrote: