Filter out Various Candidates based on Transitions processes

Summary

I am struggling with writing an OBI report that filters out specific candidates based on what Transitions processes they have against their name.

Content

We run 2 transitions processes. New Hire: and eOffer.

I am trying to filter an Analysis in OBI so that any candidate that has been hired but has not had a New Hire Process run is displayed. And any candidate that has had a New Hire process triggered is excluded altogether

The problem is, because "Process Type" creates a distinct line for each candidate, I failing at placing a filter on that filed to disregard all the candidates that I would like.