Can I create a report that shows when the logged in user is the ONLY approver that has not approved (or made a decision) yet?

[CatherineKe]

I have been asked to create a report that shows when the logged in user is the only approver that has not approved a proof (or made a decision) yet.

• all others have made a decision
• The idea is to know when the user is the person holding things up

We have a Proof Approval report, which shows all proofs where the logged in user is an approver:

• Proof Approval>>Is Current Document Version = true
• Proof Approval>>Approver ID = $$USER.ID
• Proof Approval>>Awaiting Decision = true

Option 1: Is there a way to filter the above report to only show the proofs where the logged in user is the only person that still needs to make a decision?

We also have a version of the My Document Version Report: Not Approved (originally provided by Doug Den or Kurt Jones), which shows proofs entered by the logged in user.

• It is a Document Version report
• the text mode is below

EXISTS:1:$$OBJCODE=DOCU
EXISTS:1:ID=FIELD:documentID
EXISTS:1:project:status=CUR  PLN
EXISTS:1:project:status_Mod=in
enteredByID=$$USER.ID
enteredByID_Mod=in
isCurrentVersion=true
isCurrentVersion_Mod=eq
proofApprovalStatus:proofApprovalStatusLabel=approved
proofApprovalStatus:proofApprovalStatusLabel_Mod=cine
proofedByUserID_Mod=notblank

Option 2: Can it be modified to show (only) the proofs that need a decision by the logged in user, rather than by who entered the proof?

For example, in the screenshot (below) of the existing report, “Kevin” would only see the PN18506 proof, and not the proof for PN1800

Or, is there another way to accomplish this? I appreciate any and all help - thank you!