Stats Report

Moderator: crythias

Post Reply
sajjiboy5
Znuny newbie
Posts: 3
Joined: 22 Jun 2010, 08:01
Znuny Version: 2S780

Stats Report

Post by sajjiboy5 »

Hi,

I want to generate report by customer id, which should display number of tickets generated in a specified time and how much downtime it took in the specified time period.

Can anyone help regarding this issue please?


Thanks.

Regards,

Sajjad
crythias
Moderator
Posts: 10169
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Stats Report

Post by crythias »

What did you try?
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: Stats Report

Post by crythias »

Take a look at this and see if it comes close (It's a list, not a count, but)
Title: This is a title
Object: Ticketlist
Description: Test
Format:
Sum rows: No
Sum columns: No
Cache: No
Valid: valid
X-axis
Attributes to be printed: Ticket#
Customer User
CustomerID
SolutionTime
SolutionDiffInMin
Value Series
Order by: CustomerID
Sort sequence: ascending
Restrictions
Create Time: The last 10 day(s)

It appears you might be better to start off with TicketAccumulation (?)
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
sajjiboy5
Znuny newbie
Posts: 3
Joined: 22 Jun 2010, 08:01
Znuny Version: 2S780

Re: Stats Report

Post by sajjiboy5 »

Thanks for your reply. I did what you asked me but now I am getting the following error:

Error: To much data, can't use it with graph!

Comment:
Bug Report:
Traceback: ERROR: OTRS-CGI-10 Perl: 5.8.8 OS: linux Time: Sat Jun 26 12:42:42 2010

Message: To much data, can't use it with graph!

Traceback (29739):
Module: Kernel::Output::HTML::Layout::Error (v1.176.2.17) Line: 1416
Module: Kernel::Output::HTML::Layout::ErrorScreen (v1.176.2.17) Line: 1395
Module: Kernel::Modules::AgentStats::Run (v1.74.2.2) Line: 2194
Module: Kernel::System::Web::InterfaceAgent::Run (v1.43.2.1) Line: 819
Module: /opt/otrs/bin/cgi-bin/index.pl (v1.88) Line: 48
crythias
Moderator
Posts: 10169
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: Stats Report

Post by crythias »

then don't use a graph?
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