How to create a percentage formula?

[phantom7]

I am new to servicenow analytics, and I was asked to create a widget that displays the percentage of problems that pass a certain test. The test is this:

If problem was created within the last 7 days and

Root Cause Category is not “blank” and

Task State is “Closed Complete” then that would be considered as a pass.

I have no experience with performance analytics so this is new grounds to me. Can anyone guide me on a way to complete this task? basically the percentage will be:

Problems that pass the above test / Problems that were open in the last 7 days

Thanks in advance

[Tracy Davis]

First you need 2 automated Indicators to use in the calculation. You probably need an overall 'total count of problems created in the last 7 days'

then a second one for 'count of problems with category and task complete'

Once you have both of those working you would create a formula indicator to calculate the percentage that meet your criteria.

There is more to this that is a bit lengthier to explain. Try creating the indicator of the total count first.

You also need indicator sources and collection jobs to make everything work.

I'm assuming you have PA - start looking at the out of box indicators for Problem counts. You can start by modifying what's OOB.

Hope that helps some.

[phantom7]

Thanks a lot- I followed what you advised. I have replied bellow with screenshots of what i have so far 🙂

[Zabeeulla1 · Accepted solution]

Hi Phantom,

You might require to create 2 automated indicators and 1 formula indicator.

Automated indicator:-

1.Problems that pass the above test

2.problems that were open in the last seven days.

Formula indicator

Problems that pass the above test/Problems that were open in the last 7 days.

you should have indicator sources created inorder to create an automated indicator.

Please find below links and may be of some help for you :

Automated indicators:

https://docs.servicenow.com/bundle/newyork-performance-analytics-and-reporting/page/use/performance-analytics/task/t_CreateAnAutomatedIndicator.html

Formula indicators:

https://docs.servicenow.com/bundle/newyork-performance-analytics-and-reporting/page/use/performance-analytics/task/t_CreateAFormulaIndicator.html

Indicator sources :

https://docs.servicenow.com/bundle/newyork-performance-analytics-and-reporting/page/use/performance-analytics/concept/c_IndicatorSources.html

Please let me know if you require any further help.

Regards,

Zabee.

[phantom7]

Thank you- I have created two indicator sources, two automated indicators, and a formula. Please see my reply bellow and advise on what to do next. Thanks again 🙂