PA - Open SCTASKs - Average Age, Average Age Since Update

[DJL2]

Hi all,

I'm currently overseeing a programme to analyse how well our suppliers are fulfilling tasks as we are aware that a disproportionately high number are remaining open for a considerable period of time, and this needs to be managed down.

My current approach to this is as follows:

1. Extract a daily list of Active SCTASKs [sc_task] against targeted Assignment Groups
2. Import into Excel and insert two columns:
3. Age (Days) = DAYS(TODAY,OPENED]
4. Days Since Update = DAYS(TODAY,UPDATED]
5. Build Pivot, calculate Average values and display as two daily columns.

The above can be time-consuming and I am sure there must be a way to construct similar within SNOW, but I could do with some help in achieving this.  Ideally, the output should display on a dashboard widget as columns over a time series: so, a reducing Average Age would correspond with positive behavior.

Thanks in advance for any help 🙂

[Uncle Rob]

This is basically exactly what Performance Analytics was built for.
You'd make an Indicator source similar to OOB "Incident.Open", just aimed at sc_task.
Then make a few Indicators based on that Indicator Source
- Summed Age of Open SC_Tasks (copy "summed age of open incidents and change source")
- Number of Open SC_Tasks (copy "summed age of open incidents")
- Average age open sc_tasks (copy "average age open incidents" but change the formula)
- Average age of last update of open sc_tasks (copy "average age of last update on open incidents" but change formula).

Then its just a matter of building widgets and placing them on whatever dashboard you prefer.

Easy peasy.

[Toby4]

Just to add to Robert's approach, I would suggest you take a look at PA Configuration Generator

This won't add everything you're after, but all the indicator sources and jobs will be ready to go. Looking at one I've just tested in my dev instance, the 'updated since' isn't done automatically.