Getting Breakdowns on Formula Indicators

Uncle Rob · ‎01-11-2016

Lets say I took the OOB "Incident Backlog Growth" indicator and added the OOB "Assignment Group" Breakdown.

I would suspect that I could now see the backlog growth broken down by each assignment group in the system. However, what I end up seeing is the exact same number across dozens of groups.

As I dug, I noticed that the automated indicators that act as the foundation for the formula indicator do not have the Assignment Group breakdown.

Is that a requirement I didn't know about? Must a the Auto-Indicators used in a Formula Indicators all have the same breakouts I want to use on the final Formula Indicator?

Uncle Rob · ‎01-11-2016

Robert - It looks like your hypothesis is correct. The Auto-Indicators that compose a Formula indicators seem to need the same breakdowns you intend to use on the Formula Indicator.

So OOB the formula for "Incident Backlog Growth" you have...

If you look under Auto-Indicators you'll find both of those... but if you look at the breakdowns available for "Number of New Incidents" you'll find there's no Breakdown for Assignment Group. Once I added it, I was able to successfully break down Incident Backlog Growth by group on my instance.

View solution in original post

Ben Collyer · ‎02-28-2016

Thanks Pieter,

I'll double check the source automatic indicators have the Assignment Group breakdown. I'm pretty sure they already do, but its worth checking. Not sure this is my issue though. See my response to Robert above.

Cory CJ Wesley · ‎07-16-2018

From the future...again. Appreciate it!

San6 · ‎08-21-2021

I have created a PA using this formula indicator to get incident backlog data. I've added breakdowns to include priority, assignment group and also added a bucket to sort the incidents into 1-3 days, 4-5 days, 6-10 days, 11-30 days, and Over 30-days. I had hoped that the total number of backlogged incidents that was being shown could further be broken down by these buckets. However, what I'm finding are negative numbers and only a few of the buckets have data. I'm also seeing a lot of negative numbers for the scores for the other breakdowns, which I hadn't seen before when I ran the job. Not sure why this would be returning negative numbers. Any feedback would be appreciated. Thanks so much.