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