Adding Formula to Report

Devi13
Kilo Contributor

‎02-11-2019 07:43 PM

Hi,

     We are new to Servicenow. We started using servicenow for incident management, change requests. We did generate deployment frequency reports using “Change Request”.

 We would like to calculate daily deployment rate for above report. I want to use formula : number of deployments/total days. 

We do not have performance analytics plugin. 

Any functionality in service now help me add formula?

Any response would be helpful.

Labels:
0 Helpfuls
  • 2,781 Views
1 REPLY 1

sachin_namjoshi
Kilo Patron
Kilo Patron

‎02-12-2019 09:51 PM

IF you don't have performance analytics plugin, then you can utilize custom chart functionality to calculate formula.

Please check below for more details on custom chart

 

https://docs.servicenow.com/bundle/geneva-performance-analytics-and-reporting/page/administer/report_administration/task/t_CreateACustomChart.html

 

IF you do not want custom chart plugin, then you have to create custom field on your table and then add business rules, script includes to update this calculated custom field so that you can extract reports.

 

Regards,

Sachin

0 Helpfuls