Graphical representation of open tickets

RT Users
1

Hi there!

Has anybody done a graphical representation (line graph) of open tickets
over time? Our management forced me to create such a representation.
I’m looking for a tool doing this graphing, having an x-axis as timeline
and a graph for “Created”, “Resolved” and “Open Tickets” per day (per
queue, per user?!)

Before I start to code these things I wanted to ask you, if there are
maybe some snippets of code which I could use.
Has anybody done such things before?

Greetings,
Markus

2

Hi there!

Has anybody done a graphical representation (line graph) of open tickets
over time? Our management forced me to create such a representation.
I’m looking for a tool doing this graphing, having an x-axis as timeline
and a graph for “Created”, “Resolved” and “Open Tickets” per day (per
queue, per user?!)

Before I start to code these things I wanted to ask you, if there are
maybe some snippets of code which I could use.
Has anybody done such things before?

I know two extensions:

  • RT::Extension::JSGantt: not really fit your needs but may be a base
    for coding
  • RTx::Timeline looks close to your needs, but pretty
    outdated/unmaintained

Easter-eggs Spécialiste GNU/Linux
44-46 rue de l’Ouest - 75014 Paris - France - Métro Gaité
Phone: +33 (0) 1 43 35 00 37 - Fax: +33 (0) 1 43 35 00 76
mailto:elacour@easter-eggs.com - http://www.easter-eggs.com

3

I asked the developer of RTx::Timeline, but he says he’s not using RT
anymore.

I would be very keen to get Timeline up to date as we found it excellent
with RT3, though i fear my ability to contribute might not be that
great. I was planning to take a look at it to see how out of my depth it
was

w.On 23/10/14 16:41, Emmanuel Lacour wrote:

On Thu, Oct 23, 2014 at 03:04:29PM +0200, Markus.Wildbolz@eu.magna.com wrote:

Hi there!

Has anybody done a graphical representation (line graph) of open tickets
over time? Our management forced me to create such a representation.
I'm looking for a tool doing this graphing, having an x-axis as timeline
and a graph for "Created", "Resolved" and "Open Tickets" per day (per
queue, per user?!)

Before I start to code these things I wanted to ask you, if there are
maybe some snippets of code which I could use.
Has anybody done such things before?

I know two extensions:

  • RT::Extension::JSGantt: not really fit your needs but may be a base
    for coding
  • RTx::Timeline looks close to your needs, but pretty
    outdated/unmaintained

Richard Wood (Woody)
Managing Director
Wild Thing Safaris Ltd.
PO BOX 34514 DSM
Office: +255 (0) 222 617 166
Office Mobile: +255 (0) 773 503 502
Direct: +255 657 799 468
Skype: woody1tz

4

What’s wrong with the included Chart.html?

https://rtserver/Search/Chart.html

View this message in context: http://requesttracker.8502.n7.nabble.com/Graphical-representation-of-open-tickets-tp58889p58892.html

5

As far as I know, there is no possibility to draw line-charts with the
built in charting functions.

Also, the problem I have is calculating the number of open tickets per
day.
Is there a CLI-function which I could use? I need to know the number of
open (not resolved and not rejected) at a specific day!

Greetings,
Markus