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.
Stats on answer for one ticket
Moderator: 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
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
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
Re: Stats on answer for one ticket
: No that's not an answer for meWhat about notes?
: Yes, it's typically this type of answers than I need for my purpose.If an agent says, "send more information", does that count as an "answer"
-
- 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
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
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