CSQ Activity Report by Interval

Document created by cdnadmin on Jan 25, 2014
Version 1Show Document
  • View in full screen mode

Subject: AUTO: Gregory Grebin is unavailable (returning 06/05/2013)
Replied by: GREG GREBIN on 03-06-2013 03:27:12 PM
I am out of the office until 06/05/2013.

I will have access to email and mobile phone



Note: This is an automated response to your message "New Message from JOE
CONGER in Contact Center Reporting (CCR) - Contact Center Reporting: CSQ
Activity Report by Interval" sent on 06/03/2013 03:25:12 PM.

This is the only notification you will receive while this person is away.


Prime Therapeutics made the following annotations
---------------------------------------------------------------------
CONFIDENTIALITY NOTICE: The information contained in this communication may be confidential, and is intended only for the use of the recipients named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please return it to the sender immediately and delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender.


---------------------------------------------------------------------

Subject: AUTO: Troy Dawson is out of the office (returning 06/10/2013)
Replied by: Troy Dawson on 03-06-2013 03:27:13 PM
I am out of the office until 06/10/2013.

I will be out of the office from May 31st to June 10th. I will respond to
all messages upon my return. If you need immediate assistance please
contact Greg Grebin at gfgrebin@primetherapeutics.com or Lynn Kitzrow at
lmkitzro@primetherapeutics.com. If you are having an issue or question
regarding any voice appication or other system, please contact the Service
Desk at x2000.



Note: This is an automated response to your message "New Message from JOE
CONGER in Contact Center Reporting (CCR) - Contact Center Reporting: CSQ
Activity Report by Interval" sent on 06/03/2013 03:25:12 PM.

This is the only notification you will receive while this person is away.


Prime Therapeutics made the following annotations
---------------------------------------------------------------------
CONFIDENTIALITY NOTICE: The information contained in this communication may be confidential, and is intended only for the use of the recipients named above. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication, or any of its contents, is strictly prohibited. If you have received this communication in error, please return it to the sender immediately and delete the original message and any copy of it from your computer system. If you have any questions concerning this message, please contact the sender.


---------------------------------------------------------------------
This document was generated from CDN thread

Created by: JOE CONGER on 03-06-2013 03:24:33 PM
I need a 30 minute interval report grouped by interval.
Relative Date Range: Last Week

So for the entire date range I would like to show call volume by half hour encrements over the entire date range and not listed by each day.
i.e.
                     Presented   Handled
8:00-8:30           70                67
8:30-9:00           85                80
9:00-9:30           95                89

Thanks  Joe 

Subject: RE: New Message from JOE CONGER in Contact Center Reporting (CCR) - Contact
Replied by: Steven Maas on 03-06-2013 03:49:12 PM
Should be easy enough to get accomplished…

Step 1:  Create a new report definition with the required data.

                SELECT CONVERT(VarChar(10), DateTime, 114) AS Interval, SUM(Offered) AS OFFERED, SUM(Handled) AS Handled
                FROM TableName
                WHERE (1=1)
                GROUP BY CONVERT(VarChar(10), DateTime, 114)
                ORDER BY CONVERT(VarChar(10), DateTime, 114) ASC

Note: the specific names for offered and handled change based upon which interval and or half hour table you are using.

Set 2: Create a new report


Steve Maas | Architect I - Unified Contact Center Services | Insight Networking | insight.com
o: 480.889.9892  m. 952.715.1394  steven.maas@insight.com<mailto:mike.garrity@insight.com>

From: Cisco Developer Community Forums [mailto:cdicuser@developer.cisco.com]
Sent: Monday, June 03, 2013 1:25 PM
To: cdicuser@developer.cisco.com
Subject: New Message from JOE CONGER in Contact Center Reporting (CCR) - Contact Center Reporting: CSQ Activity Report by Interval

JOE CONGER has created a new message in the forum "Contact Center Reporting": -------------------------------------------------------------- I need a 30 minute interval report grouped by interval.
Relative Date Range: Last Week

So for the entire date range I would like to show call volume by half hour encrements over the entire date range and not listed by each day.
i.e.
                     Presented   Handled
8:00-8:30           70                67
8:30-9:00           85                80
9:00-9:30           95                89

Thanks  Joe
--
To respond to this post, please click the following link: http://developer.cisco.com/web/ccr/community/-/message_boards/view_message/15830207 or simply reply to this email.

Attachments

    Outcomes