Performance Analytics indicator for Time worked on incident

[ccepts]

I am trying to create a widget with an Indicator that would show the time worked by incident priority. I can't seem to find how best to create this. Please can anyone help or provide a guidance?

Thank you

[Adam Stout]

If you are getting time worked via the time worked table, your indicator will be on the time_worked table with a breakdown on incident priority which you will need to set up a new mapping for (time_worked incident.priority).  This should pretty straight forward.

[ccepts]

Thanks a lot Adam,

I tried the strategy you proposed but got "No Data Available"

I have posted my steps below. I would appreciate any pointers as to what I am doing wrong.

[Adam Stout]

Can you include separate screenshots?  I can't read these.  To confirm, are you using the time_worked table?

https://docs.servicenow.com/bundle/newyork-platform-administration/page/administer/time/reference/r_...

Or are you just trying to derive that from wall clock based on how long the incident is open?

[ccepts]

Thank you Adam,

I am trying to get the time worked on Incidents from the Time Worked table (task_time_worked). The time worked is manually supplied based on the entries that fulfillers enter when they work incident tickets. The goal is to show on a month to month bases the total sum of time worked on Indents. Same will be done on Requests and Stories. If I can get one, I will replicate for the others.

I have provided the screen shots separately for readability.

Thank you for your help.

[Adam Stout]

I still can't read most of these, even when it blows up the image, it is still too small to read clearly.  However, a breakdown source on Sum seems very, very odd.