CSQ Activity Report by Interval

Version 1

    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.