Statistics report preview month ticket status

Moderator: crythias

Post Reply
kalyana1315
Znuny expert
Posts: 171
Joined: 24 Apr 2013, 12:29
Znuny Version: OTRS3.3
Real Name: kalyanachakravarthy M P
Company: TATA Technologies
Location: Pune,India
Contact:

Statistics report preview month ticket status

Post by kalyana1315 »

I want to create some statistics about ticket states for a period of time. I.e. I want to know how many ticket were in each state a period of one month.How can I create a report that remembers how many open tickets that were in status "new", "open", etc for a period of time (e.g. month).

i got solution only close ticket but open and new ticket facing issue.
crythias
Moderator
Posts: 10169
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Statistics report preview month ticket status

Post by crythias »

count tickets from ticket_history.
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
kalyana1315
Znuny expert
Posts: 171
Joined: 24 Apr 2013, 12:29
Znuny Version: OTRS3.3
Real Name: kalyanachakravarthy M P
Company: TATA Technologies
Location: Pune,India
Contact:

Re: Statistics report preview month ticket status

Post by kalyana1315 »

crythias wrote:count tickets from ticket_history.
hi crythias

count tickets show wrong value.

information:

i create one ticket last month state is new and same month ticket open state , next month ticket is closed.

now statistics report last month is ticket state is show close. actually status last month is open.
crythias
Moderator
Posts: 10169
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Statistics report preview month ticket status

Post by crythias »

You won't be able to do this through OTRS built-in reports.
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
kalyana1315
Znuny expert
Posts: 171
Joined: 24 Apr 2013, 12:29
Znuny Version: OTRS3.3
Real Name: kalyanachakravarthy M P
Company: TATA Technologies
Location: Pune,India
Contact:

Re: Statistics report preview month ticket status

Post by kalyana1315 »

crythias wrote:You won't be able to do this through OTRS built-in reports.

Thank crythias


any other way find solution of this issue.
crythias
Moderator
Posts: 10169
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Statistics report preview month ticket status

Post by crythias »

Yes, count from ticket_history
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
crythias
Moderator
Posts: 10169
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Statistics report preview month ticket status

Post by crythias »

explicitly, that link I gave you for how to track ticket time per state is a nice starting point.
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
Post Reply