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

Shy
Tera Contributor

‎08-29-2022 03:59 AM

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?

 

find_real_file.png

Preview file
73 KB
0 Helpfuls
  • 1,301 Views
5 REPLIES 5

Uncle Rob
Kilo Patron

‎08-29-2022 07:02 AM

There are no calculation fields in standard reporting.
You can do it in performance analytics via a formula field though.

0 Helpfuls

Shy
Tera Contributor
In response to Uncle Rob

‎08-29-2022 07:59 AM

Hi Robert, 

Are you referring to a formula indicator?

I do not see where I can easily build the filter condition below. Does this require some special form of programming?

find_real_file.png

Preview file
10 KB
0 Helpfuls

Uncle Rob
Kilo Patron
In response to Shy

‎08-30-2022 05:20 AM

That filter question wasn't in the OP.  No idea what you mean, sorry.

0 Helpfuls

suvro
Mega Sage
Mega Sage
In response to Shy

‎08-30-2022 05:23 AM

Yes formula indicator is the way to go. No other option

0 Helpfuls