Calculating Change Requests that caused Incidents trend by month.

[BradDavis]

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.

[Imran Ahmad1]

Hii @BradDavis ,

Create Database Views to connect two table and get the relationships records, after save you can create New view table select the table change_request, prefix cng( I have given you can give any) submit. create one more view table for incident.

In Database view Prefix is used to access the fields for the same table.

In list view or form write condition in Where clause

Where clause: cng_sys_id=inc_caused_by

Create report :

Select Database View Table and apply the condition

I am sharing the screenshot below it will help you and set report type Bar to count the records,rest on the thing

you can get from report only.

Regards,

Imran Ahmad

Please Mark Correct Answer:-

Please Mark Helpful:-

Please Mark as Correct Answer:-

Please Mark Helpful:-

[BradDavis]

I there a way to get the results by using out-of-the-box reporting features?

Thank you in advance.

[Imran Ahmad1]

I don't think so but you can achieve your requirement from database view, It's easy and reliable.

Please Mark correct answer :-

Please Mark Helpful:-

[Jaspal Singh]

Hi @BradDavis ,

% calculaion is not possible with OOB reporting capabilities unless you have Performance Analytics.

Also, @Imran Ahmad there isn't any need for DB view. This can be achieved by OOB reporting capabilities

without Database view.