Formula indicator not working with multi select breakdown value

HasarinFareeth
Tera Contributor

a month ago

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 Helpfuls
  • 426 Views
2 REPLIES 2

prerna_sh
Mega Sage

4 weeks ago

Hi @HasarinFareeth 
Please confirm, have you added these indicators to the job? Also, have you run any job to collect the data?

Go through following, and let me know if this will not work:
Data Collectors | ServiceNow Developers
Solved: Re: How to make a formula indicator work? - ServiceNow Community

If my response solves your query, please marked helpful by selecting Accept as Solution and Helpful. Let me know if anything else is required.
Thanks,
Prerna

0 Helpfuls

HasarinFareeth
Tera Contributor

4 weeks ago

Thank you for your response, @prerna_sh.

 

Yes. I did add my automated indicators that forms my formula indicator to the job and the job is collecting the data daily. You could see that the # in my post have actual values collected by the indicator. The problem is that the formula indicator works well when a single select is done but when I do a multiple select it is not working as expected. 

0 Helpfuls