how to calculate ticket age?

[bighorn]

can anyone show me how i can calculate ticket age between created time and close time?and to include in stat module, so that i can determine time require to solve certain issues.i'm using otrs 2.4.8.

thanks

[HervE]

Hi,

Ticket age is automatically calculated by the system: age = now - created

I think what you ask is ticket life duration = closed - created

I don't know how to calculate it in stats module, but I am interested in the answer too.

Possible workarounds:
-export the 2 dates to CSV then add an Excel formula
-use external reporting software and make a query on your OTRS database

Regards,
HervE

[bighorn]

Correct...im looking to calculate ticket life duration....
i came accross with this post http://lists.otrs.org/pipermail/otrs/20 ... 10204.html
looks promising but haven't try yet....anyone have other method pls share....and if you try the links pls share your result also...

[HervE]

Very interesting link, thank you.
If my manager asks I'll give it a try and tell you.

...But I think for more detailed stats we will use the 2 workarounds I said.

HervE