Indicator not showing all breakdowns

[mhanczuk]

Can someone help with below issue? It seems that Formula indicators are following breakdowns only partially.

I have 3 indicators that follow the same breakdowns and formula indicator that also have those set up:
Breakdowns are working fine for individual indicators, but work only partially on Formula one.

Automated Indicators (collect breakdown matrix is turned on):
> Incidents_SLA_Met
> Incidents_SLA_Missed
> Incidents_SLA_Total

Breakdowns: (Set on all indicators and formula indicator)
> Assignment Group (around 200 rows)
> Company (around 20 rows)

Formula Indicator
> Incident%

Formula looks like below:
Met = [[Incidents_SLA_Met]];
Missed = [[Incidents_SLA_Missed]];
Total = [[Incidents_SLA_Total]];
Met/Total

Now when i use Company breakdown all seems to look fine. I see results per Company and 0 values for empty lines.

Issue starts with Assignment Group. I can see only results in breakdown where there is a value for automated indicator. Otherwise group is not shown at all. (Indicators are set to display 0 for null values)

This is breaking formula indicator because if Total has a value for group that is not in Met or Missed indicator. This group is not shown in breakdown for formula indicator.

Any idea how to fix this? I need to keep all 3 indicators in formula for drill down purposes.

So far i  tried "Allow formula component to be NULL" but it did not help.

Also i do not understand why Company is listing all values while Assignment Group only those that are not null. 

[Uncle Rob]

My first strategy is self doubt.  If I was seeing that happen, I'd verify that my automated indicator and my formula indicator were using the same Breakdown and therefore the same Breakdown Source.  Breakdown source is the most obvious place that influences what breakdown elements appear, so lets rule that out first.

[mhanczuk]

Yes all indicators are using exact same breakdowns (therefore same breakdown source). 

They also share same Indicator source and Configuration. Only difference between those 3 automated is filter on Has breached field in incident_sla table. Those have been created by making 1st one and than replicating using "Insert and stay with relation" to ensure that same components are used. 

Same breakdowns are also set in Formula indicator. 

Lets say that we have 100 tickets and 2 groups:

Group A with 98 tickets missed 0 met and 98 total

Group B with 1 ticket met, 1 missed and 2 total.

On formula indicator breakdown per group is displaying only Group B with score 50%. Group A is not displayed at all, although it should with score 0%.  Without breakdown it shows correct result of 1%. 

[mhanczuk · Accepted solution]

Answer was to change PA property: com.snc.pa.breakdown_element_cutoff default setup from 50. With over 100 assignment groups, cut off on 50 started doing strange things.

[Pierre P_ Mouri]

@mhanczuk this helped me today, thank you!