monthy stats similar to 7-days statistics

Moderator: crythias

Locked
aph
Znuny superhero
Posts: 646
Joined: 20 Jun 2014, 12:11
Znuny Version: 3.3.9, 4.x, 5.x

monthy stats similar to 7-days statistics

Post by aph »

I would like to extend the 7 day stats on the dashboard and create a monthly statistics.

When creating the required stat, I can get the curve for closed tickets and curves for tickets with other states but not a (combined) curve for created tickets (similar to the one in 7-days stats on dashboard). How can I achieve this?
OTRS 3.3.x (private/testing) on Windows Server 2008 with MSSQL database.
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: monthy stats similar to 7-days statistics

Post by crythias »

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
aph
Znuny superhero
Posts: 646
Joined: 20 Jun 2014, 12:11
Znuny Version: 3.3.9, 4.x, 5.x

Re: monthy stats similar to 7-days statistics

Post by aph »

Thanks for the link.

However, creating such a widget would display the graph for all queues in the system. I don't see a way to restrict it to a certain queue. What I'm looking for though is a way to create (classic) statistics for a single queue
OTRS 3.3.x (private/testing) on Windows Server 2008 with MSSQL database.
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: monthy stats similar to 7-days statistics

Post by crythias »

The request for a single queue wasn't evident in the original question. Now I am unsure of what you want. Stat reports for a single queue or a widget.
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
aph
Znuny superhero
Posts: 646
Joined: 20 Jun 2014, 12:11
Znuny Version: 3.3.9, 4.x, 5.x

Re: monthy stats similar to 7-days statistics

Post by aph »

You are right. It was not evident. Sorry for the confusion.

What I would like to create is a Graph-lines-points where I can see the number of tickets created and number of tickets closed each day in say last 4 weeks in a particular queue.

The intended similarity to the 7-day stats refers to the visual representation (i.e. days of the month on X-Axis, a curve showing number of tickets created and another curve showing number of tickets closed).

What I've been able to achieve so far is a statistics where I have days on the X-Axis and a curve showing no. of tickets closed. What I am also able to get are curves for each state/state type but not a combined curve for tickets created (regardless of the state with which they were created).

Any pointers?
OTRS 3.3.x (private/testing) on Windows Server 2008 with MSSQL database.
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
aph
Znuny superhero
Posts: 646
Joined: 20 Jun 2014, 12:11
Znuny Version: 3.3.9, 4.x, 5.x

Re: monthy stats similar to 7-days statistics

Post by aph »

Any ideas on this one?

Is it possible to change the 7-day stats widget to show only tickets created in a particular queue? That would serve my purpose.
OTRS 3.3.x (private/testing) on Windows Server 2008 with MSSQL database.
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
crythias
Moderator
Posts: 10170
Joined: 04 May 2010, 18:38
Znuny Version: 5.0.x
Location: SouthWest Florida, USA
Contact:

Re: monthy stats similar to 7-days statistics

Post by crythias »

Requires programming. If it were evident to do it in SysConfig, you'd already have 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
aph
Znuny superhero
Posts: 646
Joined: 20 Jun 2014, 12:11
Znuny Version: 3.3.9, 4.x, 5.x

Re: monthy stats similar to 7-days statistics

Post by aph »

I very much assumed it requires development. I'll have a look at it later. at the moment my requirement is fulfilled with "classic" statistics with separate curves for each state.

Thanks for the help!
OTRS 3.3.x (private/testing) on Windows Server 2008 with MSSQL database.
OTRS 3.3.x (private/testing) on CentOS with MySQL database and apache
Locked