This was one of our major campaign KPIs prior to moving to Genesys so I was surprised to find that it was not easily available. There are two ways I found to get these.
The first one I used was not great and likely similar to what you've found - using two different reports with limited to no filtering options and a manual process.
The way I calculate it now is still not perfect, but is closer and easier and the most accurate I've been able to arrive at given the limitations of the system. I use PureInsights and created a report using two data tables (agent summary and routing status). I can use queue and agent filters to better limit the data to what I need. It's still not ideal, but it's far easier to eliminate agents that I want excluded and to get at an accurate total interactions count.
------------------------------
Emily Kammerer
Ascendium Education Solutions, Inc.
------------------------------