Breakdown Mapping for Hour of Day PA reporting

RRolling
Tera Guru

Im so close I can feel it!

but I still need some help. I created widget called 'Daily Service Desk Per Hour'

find_real_file.png

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.

find_real_file.png

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:
find_real_file.png

Breakdown:
find_real_file.png

 

Any help on why the widget doesn't show the correct incidents within the hours of the day?

12 REPLIES 12

Adam Stout
ServiceNow Employee
ServiceNow Employee

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.

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.

Adam Stout
ServiceNow Employee
ServiceNow Employee

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?

Just the oob one

find_real_file.png