I'm Troubleshooting a performance Analytics Formula indicator.

[pradeepcm]

Hello ,

@crowe1288greg 

I am troubleshooting a performance analytics formula indicator that calculates a percentage using two contributing indicators.

1) Breakdown scores exist for both contributing indicators.

2) Assignment group name and Assignment group type are configured in the breakdown source.

3)  Break down collection jobs completed successfully.

How ever , When I apply a breakdown filter , The formula indicator returns no values.

Could anyone please help me understand , What else should I verify? Are there any additional configurations required for formula indicators with breakdowns ?

Could this issue occur if the numerator and denominator indicators have different break down score data.?

Behavior Explained
Without any filter applied:
The percentage is calculated as:
(SUM In SLA / SUM Total) × 100
→ This produces the expected result (e.g., 77.9%)

With a breakdown filter applied (e.x: Assignment Group Type = Abcd-p):
The system:

Calculates percentage per data slice (e.g., per day or breakdown segment)
Then averages those percentage values

This results in:
AVG(daily or sliced percentages)
→ Which can lead to inflated values (e.g., 75% or 81%)

Example Provided
Total: 1000
In SLA: 779
Expected: 779/ 1000 × 100 = 77.9%
Dashboard shows: 81%

Any suggestions would be greatly appreciated .

[nitin gupta1]

Hi,

One thing I'd suggest checking is whether the numerator and denominator indicators have matching breakdown score data for the selected breakdown element.

Even when breakdowns are configured correctly and collection jobs complete successfully, a formula indicator can return blank or unexpected values if the contributing indicators do not have aligned breakdown scores (same breakdown elements and score dates).

Also, the behavior you're seeing with the percentage changing after applying a breakdown may be related to how Performance Analytics aggregates formula indicators. In some cases, PA calculates the percentage for each slice (for example, each day or breakdown element) and then averages those percentages, rather than calculating:

(SUM Numerator / SUM Denominator) × 100

This could explain why the expected result is 77.9% while the dashboard shows 81%.

I'd recommend validating:

• Breakdown scores exist for both numerator and denominator indicators.
• The same breakdown elements are present in both indicators.
• Score dates align between both indicators.
• Widget aggregation settings are not averaging percentage values.

Have you compared the breakdown score records for the numerator and denominator indicators for the specific Assignment Group Type value?

[pradeepcm]

Hi @nitin gupta1 

Thank you @nitin gupta1  for your time , Please let me go through ! I will verify the breakdown scores, and score dates for both contributing indicators.

Could you please also let me know where I can compare the breakdown score records in performance analytics ? Is there a specific table or module that you recommend  checking ?

Thanks & Regards 

Pradeep M

[AndersBGS]

Hi @pradeepcm 

Have you ensured to attached the breakdown till both automated indicators and formula indicator? Have job you ran the job after you have attached the breakdown?

[crowe1288greg]

Hello,

Just to level set, you've confirmed that when you review scores for the automated indicators, their are scores within the breakdown elements?

Have you added the breakdown to the formula indicator?

Are you viewing the formula indicator within a widget or on the Analytics Hub?