I have a requirement to fetch records showing both breached and non-breached RITMs.
My goal is to calculate the RITM Success Percentage, which is defined as:
(Not Breached = false / Total Count) × 100
However, in regular reporting using Multi-Pivot, the Functional Field option is disabled, so I’m unable to perform this calculation there.
Could anyone please suggest how to achieve this in Performance Analytics (PA) or share an alternate way to calculate and display this percentage?
If it’s achievable with PA, what would be the best way to visualize it (e.g., Scorecard, Pivot Table, Breakdown, etc.)?
Example output:
Item Owner | Total Count | Breached = false | RITM Success % |
User 2 | 19 | 15 | 78.9% |
User 1 | 1309 | 933 | 71.3% |
User 3 | 2 | 1 | 50% |
