Stat graph

[jme]

Hi,

Could you help me to build some stat report.

My boss ask me to give him a monthly graph-report with the resolution time and first answer time per ticket or a average time for the month ?

Any idea how to build it with the stat module ?

Thx

[jme]

Hi,

i've found to get the graph, with the default stat module: List of tickets closed, sorted by solution time

I've change it a little bit:

Stat#: 10006
Titre: List of tickets closed, sorted by solution time
Objet: Liste des tickets
Description: List of tickets closed last month, sorted by solution time.

NOTE: Please check the output and configuration of the statistics
carefully to make sure that it produces the results you expect. If
necessary, change the configuration before using the statistics
productively.
Format: CSV
Ligne de somme: Non
Colonnes de somme: Non
Cache: Non
Valide: valide
X-axis
Attributs à imprimer: Ticket#
FirstResponseInMin
SolutionInMin
Séries de valeurs
Trier par: SolutionInMin
Ordre de tri: ascendant
Restrictions
File: Support
Support::Enterprise
Support::SMBS
Date de clôture: Entre 2010-07-01 00:00:00 et le 2010-07-12 23:59:59

This give me a csv file, i have to do some change in it to get this graph:



Any idea if it's possible to use the stat module to get the graph directly from OTRS and not use excel ?

Thx

[jme]

I get it:

Stat#: 10013
Titre: List of tickets closed, Resolution time
Objet: Liste des tickets
Description: List of tickets closed Resolution Time Graph

Format: Graphique-Barres
Taille du graphique: 1200x800
Ligne de somme: Non
Colonnes de somme: Non
Cache: Non
Valide: valide

X-axis
Attributs à imprimer: Ticket#
SolutionInMin


Séries de valeurs
Trier par: Ticket#

Ordre de tri: ascendant


Restrictions
File: Support
Support::Enterprise
Support::SMBS

Date de clôture:
Entre 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 . 01 02 03 04 05 06 07 08 09 10 11 12 . 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 et le 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 . 01 02 03 04 05 06 07 08 09 10 11 12 . 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011
(Période maximale de 01.07.2010 00:00:00 vers 12.07.2010 23:59:59)

Stat#: 10014
Titre: List of tickets closed, First Response Time
Objet: Liste des tickets
Description: List of tickets closed First Response Time Graph

Format: Graphique-Barres
Taille du graphique: 1200x800
Ligne de somme: Non
Colonnes de somme: Non
Cache: Non
Valide: valide

X-axis
Attributs à imprimer: Ticket#
FirstResponseInMin


Séries de valeurs
Trier par: Ticket#

Ordre de tri: ascendant


Restrictions
File: Support
Support::Enterprise
Support::SMBS

Date de clôture:
Entre 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 . 01 02 03 04 05 06 07 08 09 10 11 12 . 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011 et le 01 02 03 04 05 06 07 08 09 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 . 01 02 03 04 05 06 07 08 09 10 11 12 . 2000 2001 2002 2003 2004 2005 2006 2007 2008 2009 2010 2011
(Période maximale de 01.07.2010 00:00:00 vers 12.07.2010 23:59:59)

Any idea if we can print near the ticket number, the customer name?