Formula indicator not working with multi select breakdown value

HasarinFareeth
Tera Contributor

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 :

HasarinFareeth_0-1754045800521.png
Values when a single option is selected:

HasarinFareeth_1-1754045896429.png

Values when 2 elements are selected in the filter:

HasarinFareeth_2-1754046054184.png

The expected SLA % in the above scenario should be 58.33% (7/12).

Can you please advise if I am missing anything?

Thanks

Fareeth

 




 

0 REPLIES 0