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

[ccepts]

I have pasted them individually. I hope it's clearer now. I am appreciative.

Indicator Source

Indicator

Breakdown Source

Breakdown

[Adam Stout · Accepted solution]

1) Remove the breakdown source.   I'm not sure what you want, but that isn't right.  It should probably be based on sys_choice and priority (which already exists anyway).

2) If you have a daily indicator, you indicator source should be daily.  You'll be counting the monthly number every day which would be very odd.

3) Based on task close is also a little weird (but ok).  Why wouldn't you sum up the time worked based on when it was worked?

[ccepts]

Lawd Adam, I am so appreciative of your guidance.

What I am trying to achieve is so direct. 

I want to be able to get "Sum of the Time Worked on Incident" so I can see these totals over month for every Incident priority. My overall goal is to see total sum of Worked Time for every Incident priority. So I can see how many hours my team worked every month. That way, I can show that we are able to take on additional projects or request additional resources. 

1. I changed Indicator source condition to (Worked Date on Today)

2. When I removed the breakdown as instructed, I saw a figure that looked like the sum total of time worked in the system. Something like 229K hours. When I did a manual sum, I believe I got 80hrs for this month

My anticipated outcome is similar to something like the depiction below:

I believe there is something I am not getting right. 

[Adam Stout]

1) I would expect that the time worked for yesterday would be near 0 (if you only have 80 hours this month).  You need to run a historical job to gather the daily numbers for the past 60, 90, 180 days, etc.

2) You breakdown should use the existing breakdown to incident priority, just add a new mapping to the time worked table.

[ccepts]

Your guidance has been so helpful. I finally got it to work by reading all your comments and following redoing everything one paying attention to the steps. This has been so enlightening. Much respect for PA and you. 🙂

Best wishes and thank you once again Adam.