Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

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
  • 2,267 Views
6 REPLIES 6

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
In response to Shy

‎08-30-2022 05:23 AM

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

0 Helpfuls