Formula indicator not working with multi select breakdown value
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
08-01-2025 04:03 AM
Hello there
I have created a dashboard where I have a 1 formula and 2 automated indicator widgets. I also have a breakdown filter added into the dashboard. The formula widget provides me with the SLA % of the incident closed and the 2 automated indicators provides me the total number of closed incidents and number of closed incidents met SLA. The breakdowns are added correctly in all the 3 indicators and the indicators are set to follow the breakdown in the dashboard.
When I select a single value in the breakdown filter in the dashboard, all the 3 indicators works as expected and provides me with the correct values but if I select multiple values from the dashboard breakdown filter, only the automated indicators provides me correct values, the formula indicator provides the default which was the one when no options are selected in the dashboard indicator.
The SLA % is a % of No of P3 Incident Response (Current) / No Total Number of Incident Response SLAs (Current).
Values when no options are selected in the supplier filter :
Values when a single option is selected:
Values when 2 elements are selected in the filter:
The expected SLA % in the above scenario should be 58.33% (7/12).
Can you please advise if I am missing anything?
Thanks
Fareeth