I'm Troubleshooting a performance Analytics Formula indicator.

pradeepcm
Tera Contributor

2 hours ago

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 .

0 Helpfuls
  • 69 Views
1 REPLY 1

nitin gupta1
Tera Contributor

2 hours ago

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?

0 Helpfuls