Formula indicator for % calculation incorrect when using breakdowns

[Mark D]

I have recently created a Formula Indicator which works out a percentage for % successful changes which needs to be filtered via Breakdowns over two layers.

the formula is simply [number of successful changes / month SUM +] / [total number of changes /month SUM +] * 100

I have added the required number of breakdowns within the formula but also all the contributing indicators.

When I filter the first selection [Business area] the formula works fine but the moment I select business area and drill into it further within analytics hub and expand upon [Primary impacted Service] I am expecting to see values there anywhere between 0 - 100% however I am presented with very High percentages eg 143.87k% so obviously the calculations are no longer working 

[jeffrubinoff · Accepted solution]

Are the breakdown matrices being calculated for both contributing indicators? Your result suggests that it is being calculated for Total number of changes but not Number of successful changes. https://docs.servicenow.com/bundle/vancouver-now-intelligence/page/use/performance-analytics/concept...

[jeffrubinoff · Accepted solution]

Are the breakdown matrices being calculated for both contributing indicators? Your result suggests that it is being calculated for Total number of changes but not Number of successful changes. https://docs.servicenow.com/bundle/vancouver-now-intelligence/page/use/performance-analytics/concept...

[Mark D · Accepted solution]

Yes I have breakdowns for Business area and Primary Impacted service in both indicators and within the Formula if I select just Primary impacted service the formula works fine, if I select just the business area the formula works ok but If I select business area then PIS the percentages are massively out - any ideas please anyone

[Mark D]

Apologies you are correct forgot to tick collect Breakdown Matrix 😞 for successful changes out of interest rather than having blanks for services which have had no changes in the month is there a way to not show them in Analytics Hub?

[jeffrubinoff]

There is a way to fix this in a system property for the whole instance but not for specific indicators.
Also, if my earlier comment was helpful, could you please mark it as such?