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
X-Axis
Result:
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.
Reports not working as intended
Moderator: crythias
-
- Znuny newbie
- Posts: 39
- Joined: 20 Mar 2021, 12:21
- Znuny Version: Znuny LTS 6.0.36
- Real Name: Robin
Reports not working as intended
Last edited by Rhendak on 14 Oct 2021, 09:43, edited 1 time in total.
-
- Administrator
- Posts: 4002
- Joined: 18 Dec 2007, 12:23
- Znuny Version: Znuny and Znuny LTS
- Real Name: Roy Kaldung
- Company: Znuny
- Contact:
Re: Reports not working as intended
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
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 and Znuny LTS running on 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 where it goes ?
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 where it goes ?
-
- Znuny newbie
- Posts: 39
- Joined: 20 Mar 2021, 12:21
- Znuny Version: Znuny LTS 6.0.36
- Real Name: Robin
Re: Reports not working as intended
That's exactly what I did, however the ticket list does not show any tickets during the weekends.
Same settings:
Y-Axis
X-Axis
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
Last edited by Rhendak on 14 Oct 2021, 09:43, edited 1 time in total.
-
- Znuny newbie
- Posts: 39
- Joined: 20 Mar 2021, 12:21
- Znuny Version: Znuny LTS 6.0.36
- Real Name: Robin
Re: Reports not working as intended
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 not applied. However if you add the statistic to your dashboard, it shows accurate results.
During the creation of the report, it does not show an accurate results of the report, because the filters are not applied. However if you add the statistic to your dashboard, it shows accurate results.