Is there a way to force unique records only?
John,
I don't know of a way or formula that works for this in the query, I generally will create this type of query in either a SQL query or SEI.
A couple different workarounds.
1. Create a SQL view under "development > Data and parameter > views". You can use SQL comment to make your selection unique, then you can pull in into a Graphical Query as a regular table.
2. In the Graphical Query, create a group for the fields that are unique in your query. So when you "Level -", you can see the unique result by group.
Yes, the 2nd option can work but it's not the prettiest option.
*Community Hub is the new name for Sage City