PA | Oldest Ticket by Age, breakdown by Assignment Group

[DJL2]

Hi all,

I'm keen to understand if it possible to create an indicator within PA, which analyses all Open Incidents within an Assignment Group and returns as a score, a number (in Days) of the oldest Incident?  So, if I was to do this in Excel, I'd calculate (TODAY-Opened) to derive an elapsed number, and then use MAX formula to return the highest value.  And this is how this MI is currently calculated - however I'm sure PA must be able to replicate this?

I've had a go this morning, by: choosing the MAX option when asked how to aggregate and I believe I pointed to the Opened field.  I ran the job but no scores were collected - so, clearly I'm not applying something correctly.

Any help?

Thanks.

[Adam Stout · Accepted solution]

Did you look at the OOTB indicators and breakdowns?  There should be an Age breakdown that already exists as a scripted indicator.  Reuse the same script and then run a MAX indicator on that.

[DJL2]

Adam, that is perfect!

I'd missed the bit where I needed to run an Age Script (...instead, I was aggregating Maximum)

Thank you!