Breakdown Mapping for Hour of Day PA reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-29-2020 01:36 PM
Im so close I can feel it!
but I still need some help. I created widget called 'Daily Service Desk Per Hour'
The widget should show a breakdown of incidents per hour from the following day.
the issue is the incidents are not created and displayed in the correct column as you can see below.
In this example I clicked on the column for incidents opened from 11:00-12:00 but it show opened incidents from 4:00-5:00.
Widget:
Breakdown:
Any help on why the widget doesn't show the correct incidents within the hours of the day?
- Labels:
-
Dashboard
-
Performance Analytics
-
Reporting
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-29-2020 03:19 PM
The 11-12 is the time the data collector (Performance Analytics script) saw. Either the job is set to that timezone (different than yours) or the script is always using UTC and needs to be updated to something that gives you local (to the job's timezone) hours.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-29-2020 04:10 PM
My timezone is set to US/Pacific and the job ([PA Incident] Daily Data Collection) is set in US/Eastern because its the default. However, the 11am-12pm column is showing incidents from 4am-5am which is way more than the 3 hour difference in timezone
Ive also checked with another Admin that is in the Eastern timezone and his 11am-12pm column shows incidents from 7am-8am. I'm not sure what to change since the timezone even looked wrong from within the same timezone.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-29-2020 04:54 PM
My guess is the script is using a method that gets the hour of the day in UTC (PDT +7 hours). That probably needs to be updated. Can you share the script used for the mapping?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎04-29-2020 05:46 PM