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-24-2016

Thanks for replying and marking correct solution, but have you checked the palms of your hands for hairs lately?

If automated indicator x has a breakdown of assignment_group and I "browse for an indicator", while building a formula indicator, automated indicator x should have a breakdown of assignment_group in that pick tree right? Cause ours don't (Fuji). Any suggestions?

Ben.

Uncle Rob · ‎02-25-2016

So is the issue that when you visualize the formula indicator, you're not seeing the Assignment Group as an available breakdown?

Ben Collyer · ‎02-28-2016

No.

When creating a formula and clicking "Browse for an indicator" it displays a list of indicators. If you click the plus next to the indicators you can drill down into them and return a specific breakdown of an indicator. For example: [[Number of closed changes / Subcategory / Enhancement]] to return values from the Number of closed changes indicator using the subcategory breakdown to only return those where subcategory is Enhancement.

If the Number of closed changes has a breakdown "Assignment group" it is visible if you view the indicator directly (Breakdowns related list), but not through the the "Browse for an indicator" tree view.

pieter_goris · ‎02-26-2016

Hi Ben,

just to make sure: when you want to breakdown a formula indicator, you do not define that in the formula but like with the automated indicators, you add the breakdown to the breakdown section at the bottom of the formula indicator form.

Now, if one of the indicators is not broken down by the breakdown you selected for the formula indicator, than, as Robert stated earlier, the breakdown scores for the formula will all have the same value.

@Robert: OOB the 'number of new incidents' does not have the assignment group breakdown because by the time the breakdown scores are collected the new incidents might already have bee re-assigned to another assignment group.

Uncle Rob · ‎02-26-2016

Yeah that realization was beginning to dawn on me the other day as a couple teams have expressed interest in using PA to help them reach goals of reducing time in various states. Its certainly not a common use case, so I'm thinking of ways I could use PA combined with Metric Definitions.