Join the #BuildWithBuildAgent Challenge! Get recognized, earn exclusive swag, and inspire the ServiceNow Community with what you can build using Build Agent.  Join the Challenge.

Calculating Change Requests that caused Incidents trend by month.

BradDavis
Tera Contributor

Hello, 

I am trying to create a report that will show total monthly changes and also what %/count of those changes caused incidents. 

(Jan Incidents Caused by Change) / (Jan Total Changes) = %

 Example:

  • In Jan if we made 100 changes and there were 3 incidents caused by change the % would be 3/100 = 3%

Thank you in advance.

5 REPLIES 5

BradDavis
Tera Contributor

I was thinking something along these lines. I would want the visualization to show 

1. Total Number of Changes 
2. Count of Changes that caused Incidents

@Jaspal Singh, Thank you so much for getting me this far.

 

find_real_file.png