Stats on answer for one ticket

Moderator: crythias

Locked
legmurd
Znuny newbie
Posts: 2
Joined: 23 Nov 2012, 18:13
Znuny Version: 3.0.3

Stats on answer for one ticket

Post by legmurd »

Hi everybody,

My customer relationships use OTRS in a large way, and we are totally satisfied by this product.

But I try to obtains a particular statistics : I need to know how many answers a single Ticket can have before he was closed.

Thanks for your help.
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Stats on answer for one ticket

Post by crythias »

Explicitly define "answer". Are you looking for *any* number of agent-external-email? What about notes? If an agent says, "send more information", does that count as an "answer"?
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
legmurd
Znuny newbie
Posts: 2
Joined: 23 Nov 2012, 18:13
Znuny Version: 3.0.3

Re: Stats on answer for one ticket

Post by legmurd »

What about notes?
: No that's not an answer for me
If an agent says, "send more information", does that count as an "answer"
: Yes, it's typically this type of answers than I need for my purpose.
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Stats on answer for one ticket

Post by crythias »

you can perform a sql count on the number of articles that match the type of article that counts (external-email) and sender type = agent.
OTRS 6.0.x (private/testing/public) on Linux with MySQL database.
Please edit your signature to include your OTRS version, Operating System, and database type.
Click Subscribe Topic below to get notifications. Consider amending your topic title to include [SOLVED] if it is so.
Need help? Before you ask
Locked