Report to show missing records from another report

Deseree Karns
Tera Contributor

Hello!

I have two single score reports that show the following information:

Report 1:  The number of Changes that were closed yesterday

Report 2:  The number of Changes that were closed yesterday that had Approval to close

 

Both reports are pulled from the same DB view table (joins Change Request and Approver table).

We have a problem when Report 1 single score is greater than Report 2 single score.  

 

Current:  Today, if these two report scores are different, we download each report in Excel, copy the Change # column from Report 2 and add to Report 1, then do a comparison to see what record is missing from Report 2.  This is a very manual process. 

 

Desired:  We would like to combine these two reports to ONLY show the number of missing records (this would the the difference of Report 2 from Report 1), so we don't have to do the manual comparison in Excel.

 

Is there a way to accomplish this either in PA or reporting?  I have not been successful in getting this to work.

 

Thanks!

0 REPLIES 0