Report to show missing records from another report
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-21-2024 08:15 AM - edited 03-21-2024 08:59 AM
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!