Some PDIs are currently unavailable, and PDI actions are paused. View the latest updates here. Read More

Attempting to make a Data Visualization of MTTR for 19 INCs

AshleyMalon
Giga Contributor

yesterday

Hello everyone,

 

I'm brand new to PA and have been doing as much learning as possible to understand how to make my own Data Visuals. 
However, I'm struggling on creating a data visualization for MTTR for only 19 INCs. I know how to filter and display these 19 INCs with no issues. I know where to pull the indicator for MTTR. My biggest issue is getting everything together to play nicely and I feel like I might've over thought the process. 

I've looked into previous forum posts but struggled.
Where I am at right now is that I possibly don't need to do create a Job/Report to pull my 19 INCs just to have the MTTR formula indicator to work.
I've read that it's possible to just plug in my 19 INCs table and somehow connect the OOB MTTR to it or I might be completely understanding that process wrong, but that is why I'm posting here. 

So all I want to do is display MTTR for 19 INCs that were filtered out from over 500 INCs. 

0 Helpfuls
  • 82 Views
2 REPLIES 2

Vikram Reddy
Tera Guru

yesterday

Hello @AshleyMalon,

 

Breakdown Source (pa_breakdown_sources)
  Type: Table
  Facts table: Incident [incident]
  Field: Number
  Filter: numberIN INC0010001,INC0010002,...,INC0010019

Breakdown: create from the source above
Indicator: Mean Time to Resolve (OOB)
  Related List > Breakdowns > add the new breakdown
  Then rerun the indicator's collector job so scores get calculated against it

You don't hand your 19 INCs to MTTR as a separate table, you scope MTTR down to them with a Table-type breakdown source filtered to those 19 numbers (or sys_ids), turn that into a breakdown, and attach it to the OOB Mean Time to Resolve indicator. One thing that trips people up: existing collected scores won't retroactively reflect a brand new breakdown, so you have to rerun the collection job for that indicator before the Data Visualization will show anything for it.

 

Thank you,
Vikram Karety
Octigo Solutions INC

0 Helpfuls

AshleyMalon
Giga Contributor
In response to Vikram Reddy

6 hours ago

Hello @Vikram Reddy ,

 

I've followed your process but when I executed my job it came back with Warnings and no Inserts. I thought my org had a OOB Mean Time indicator but they only have the formula indicator for it instead. I tried making my own indicator but I think thats where the issue currently is. 

0 Helpfuls