Reports not working as intended

Moderator: crythias

Post Reply
Rhendak
OTRS newbie
Posts: 22
Joined: 20 Mar 2021, 12:21
Znuny / OTRS Version: Znuny LTS 6.0.36
Real Name: Robin

Reports not working as intended

Post by Rhendak »

Hello all,

I'm trying to create a report, that shows the amount of created tickets over the last month. However, when doing so, I also notice that there are tickets created during the weekend, which is generally not the case in our situation. As a result of this, I tried tampering with the filter applied (applying different queue filters), but to my surprise, the results stay the same. It seems as if the filter is not applied.

Here are my settings:
Y-Axis
Image

X-Axis
Image

Filter
Image

Result:
Image

Does anyone know what I'm doing wrong, or why it seems like the filters are not applied?

Thanks for any help offered in advance,

Kind regards,
Robin.
root
Administrator
Posts: 2872
Joined: 18 Dec 2007, 12:23
Znuny / OTRS Version: Znuny LTS and 4/5/6
Real Name: Roy Kaldung
Company: Znuny
Contact:

Re: Reports not working as intended

Post by root »

Hi,

I would check first the settings with a ticket list to make sure that there are really no ticket on the weekend. I hav the same issue one time and it was the SystemMonitoring pugin which also closed the ticket by itself if needed.

- Roy
Znuny LTS and ((OTRS) Community Edition CentOS / RHEL / Debian / SLES / MySQL / PostgreSQL / Oracle / OpenLDAP / Active Directory / SSO

Use a test system - always.

Do you need professional services? Check out https://www.znuny.com/

Do you want to contribute or want to know why ?
Rhendak
OTRS newbie
Posts: 22
Joined: 20 Mar 2021, 12:21
Znuny / OTRS Version: Znuny LTS 6.0.36
Real Name: Robin

Re: Reports not working as intended

Post by Rhendak »

root wrote: 14 Sep 2021, 11:44 Hi,

I would check first the settings with a ticket list to make sure that there are really no ticket on the weekend. I hav the same issue one time and it was the SystemMonitoring pugin which also closed the ticket by itself if needed.

- Roy
That's exactly what I did, however the ticket list does not show any tickets during the weekends.

Same settings:
Y-Axis
Image

X-Axis
Image

Filter
Image

Result

Code: Select all

Created
2021-08-31 16:12:18
2021-08-31 15:51:13
2021-08-31 11:00:10
2021-08-31 10:48:08
2021-08-31 09:40:03
2021-08-31 09:39:36
2021-08-31 09:39:12
2021-08-31 09:12:05
2021-08-31 08:51:21
2021-08-31 08:39:18
2021-08-30 17:09:16
2021-08-30 17:09:15
2021-08-30 16:15:03
2021-08-30 16:12:03
2021-08-30 15:06:08
2021-08-30 13:15:09
2021-08-30 12:14:20
2021-08-30 11:54:12
2021-08-30 09:46:53
2021-08-30 09:36:02
2021-08-30 01:09:14
2021-08-27 15:38:59
2021-08-27 15:21:23
2021-08-27 14:42:18
2021-08-27 14:14:08
2021-08-27 09:46:48
2021-08-27 09:41:37
2021-08-27 09:23:37
2021-08-27 09:12:04
2021-08-27 00:00:05
2021-08-26 15:33:53
2021-08-26 15:03:21
2021-08-26 15:03:20
2021-08-26 14:00:14
2021-08-26 13:09:10
2021-08-26 11:42:52
2021-08-26 11:42:00
2021-08-26 10:18:15
2021-08-25 16:23:53
2021-08-25 15:56:16
2021-08-25 15:45:15
2021-08-25 15:33:16
2021-08-25 15:33:14
2021-08-25 15:06:12
2021-08-25 14:54:10
2021-08-25 14:21:08
2021-08-25 13:57:06
2021-08-25 10:54:11
2021-08-25 09:24:04
2021-08-24 17:09:08
2021-08-24 16:57:07
2021-08-24 16:09:03
2021-08-24 15:48:21
2021-08-24 15:24:12
2021-08-24 15:12:18
2021-08-24 11:42:22
2021-08-24 11:42:20
2021-08-24 09:09:08
2021-08-24 09:06:08
2021-08-24 08:43:17
2021-08-23 17:03:03
2021-08-23 16:24:20
2021-08-23 15:52:58
2021-08-23 15:52:28
2021-08-23 14:56:36
2021-08-23 13:27:05
2021-08-23 12:30:21
2021-08-23 12:03:18
2021-08-23 12:00:56
2021-08-23 11:48:17
2021-08-23 11:33:16
2021-08-23 09:57:07
2021-08-23 09:36:06
2021-08-20 15:00:05
2021-08-20 13:06:16
2021-08-20 10:33:34
2021-08-20 10:18:17
2021-08-20 10:04:08
2021-08-20 09:39:19
2021-08-20 09:27:18
2021-08-19 17:21:07
2021-08-19 16:51:12
2021-08-19 16:27:49
2021-08-19 16:10:36
2021-08-19 15:28:51
2021-08-19 13:30:07
2021-08-19 12:54:04
2021-08-19 12:30:02
2021-08-19 11:03:43
2021-08-19 10:44:56
2021-08-19 10:44:18
2021-08-19 10:43:36
2021-08-19 10:15:11
2021-08-18 12:18:14
2021-08-17 17:54:06
2021-08-17 14:15:07
2021-08-17 14:00:06
2021-08-17 12:33:19
2021-08-17 11:42:15
2021-08-17 11:03:12
2021-08-17 10:21:08
2021-08-17 09:18:03
2021-08-17 09:16:08
2021-08-17 08:27:19
2021-08-16 17:18:10
2021-08-16 17:03:12
2021-08-16 15:57:03
2021-08-16 15:24:13
2021-08-16 08:39:04
2021-08-15 11:03:08
2021-08-13 18:15:17
2021-08-13 14:09:16
2021-08-13 13:39:14
2021-08-13 12:06:06
2021-08-12 16:46:27
2021-08-12 16:41:01
2021-08-12 15:17:27
2021-08-12 15:10:48
2021-08-12 15:07:15
2021-08-12 14:22:31
2021-08-12 14:08:45
2021-08-12 14:04:15
2021-08-12 09:36:04
2021-08-11 16:42:05
2021-08-11 15:30:18
2021-08-11 15:03:16
2021-08-11 13:03:06
2021-08-11 12:06:21
2021-08-10 19:39:17
2021-08-10 16:39:03
2021-08-10 14:57:13
2021-08-10 14:09:09
2021-08-10 11:45:17
2021-08-10 11:12:14
2021-08-09 14:42:07
2021-08-09 12:42:16
2021-08-09 12:39:17
2021-08-09 12:39:16
2021-08-09 12:36:16
2021-08-09 11:18:09
2021-08-09 11:15:09
2021-08-09 11:09:08
2021-08-09 10:57:09
2021-08-09 10:57:08
2021-08-09 10:42:06
2021-08-06 12:45:14
2021-08-06 11:09:07
2021-08-06 11:03:06
2021-08-06 10:18:03
2021-08-06 10:00:21
2021-08-06 09:57:21
2021-08-06 09:48:20
2021-08-06 09:33:19
2021-08-06 09:03:16
2021-08-06 07:45:10
2021-08-05 18:45:17
2021-08-05 16:45:07
2021-08-05 16:15:05
2021-08-05 14:30:16
2021-08-05 13:15:15
2021-08-05 11:33:02
2021-08-05 09:21:12
2021-08-04 11:18:13
2021-08-04 10:54:12
2021-08-04 10:54:11
2021-08-04 09:23:05
2021-08-04 09:21:05
2021-08-04 09:16:38
2021-08-04 09:11:16
2021-08-04 08:54:03
2021-08-03 14:37:10
2021-08-03 14:31:00
2021-08-03 14:28:28
2021-08-03 11:16:34
2021-08-03 08:54:10
2021-08-03 08:54:09
2021-08-03 08:42:08
2021-08-03 08:24:06
2021-08-03 08:12:05
2021-08-03 07:51:04
2021-08-02 16:30:14
2021-08-02 15:18:08
2021-08-02 14:27:03
2021-08-02 14:10:08
2021-08-02 12:15:13
2021-08-02 10:54:07
The above doesn't mention any dates in the weekend. The only thing not included in this filter is the "type", which in the graphs is set to "Incident and RFA". I'd only assume that when the type is not set, it includes all types.
Rhendak
OTRS newbie
Posts: 22
Joined: 20 Mar 2021, 12:21
Znuny / OTRS Version: Znuny LTS 6.0.36
Real Name: Robin

Re: Reports not working as intended

Post by Rhendak »

I managed to fix this.

During the creation of the report, it does not show an accurate results of the report, because the filters are now applied. However if you add the statistic to your dashboard, it shows accurate results.
Post Reply