How do I pull two counts in Reporting and divide them in ServiceNow?

[Shy]

I am wanting to capture the Count of All Closed Incidents from a particular assignment group and divide it by the Count of All Closed Incidents from All Groups.

Example:

Count(All Closed Incidents from "HR Benefits" Assignment Group) ÷ Count(All Closed Incidents From All Groups)

What method do I need to use to pull this information?

[Mohith Devatte]

hello,

you can create two automated indicators and one formula indicator for this 

1) first automated indicator should contain filter as assignment group is your assignment group name and state is closed and  unit as "#" which indicates count.

2) Second automated indicator where condition can be like state is closed 

3)Formula Indicator - with a formula of 

[first indicator name]/[second indicator name] 

Hope this helps 

please mark my answer correct if this helps you

[Mark Becker]

I hope this changes one day but I think in order to do this you can use the calculator on your computer to do 206/332. However, the way I understand it you have to create:

1) Indicator Source on the table you want to measure. If there's 2 different tables then 2 indicator sources (if they're not already created)

2) Automated indicator #1 (Closed Benefits cases)

3) Automated indicator #2 (total closed cases)

4) Formula indicator - (Benefits indicators)/ (closed indicator)

5) Historical Job Data collector

6) Daily job data collector

7) add the 2 automated indicators and run historical data job collector for 3, 6, 9 whatever months you want

😎 add the 2 automated indicators into the daily job and make sure it's active going off each morning

9) Once historical data is collected you have to then create a widget to show the % on a dashboard

10) add that widget to the dashboard.

You also then have to make sure you're filtering properly on date ranges in the widget. Also, don't forget if you want to filter on any columns in those tables those also need to be breakdowns added to those three indicators.

So if you want to filter on Category 1 say. You need to create:

1) Breakdown source

2) Breakdown

3) Add those breakdowns to all 3 indicators

The nice thing is once ALL this is set up. It's pretty much hands off and everything runs automatically 🙂