Looking to combine CSQ reports for UCCX and add a new datapoint.

[Ken Beck]

I'm looking to combine two CSQ reports together for UCCX.  The Contact Service Queue Activity Report by Interval and the Contact Service Queue Activity Report.  I also need to add the maximum number of calls in Queue for the given interval.  I'll also need another interval added of 24 hours or 1440 minutes.  Right now there is only report range, 30, and 60 minute choices.

I have CUIC premium and have imported these two reports but need some help.  Has anyone done this before?

[vigurura · Accepted solution]

you need to implement a custom report with a new stored procedure that aggregates the required data available separately in the two individual reports. Also, you need to create the 1440 minutes filter as part of the custom report definition creation.

You can refer to the whitepaper detailing how to create custom reports with UCCX. The link of the whitepaper is here