Queue Item Report - Count transaction only once and remove retries

I am looking to put together a table to find the total number of transactions with the status of successful, business exceptions, and application exceptions for a given date. I am having a challenge with eliminating retries from it. For example, we had nine retries on 11/14, and the final try was successful for each transaction, so I want to exclude nine application transactions since the final status was a success. Please let me know if there is a way to remove retries from it.

1 Like