The issue im running into is that I keep getting duplication in the report instead of something simple
Is this a custom query that you've written or are you just using the query builder? It seems like if you only want the latest status you can select max(timestamp) or just removing that field should get you the single rows.
Either way, knowing more about how you built the report and what you're trying to display will help us help you.
