Legacy Dev Forum Posts

 View Only

Sign Up

Count number of abandoned/offered calls for a specific queue for given time period

  • 1.  Count number of abandoned/offered calls for a specific queue for given time period

    Posted 06-05-2025 19:06

    kayb | 2019-08-14 21:58:37 UTC | #1

    Hi,

    I have written SQL query against conversation detail data. (https://api.mypurecloud.com/api/v2/analytics/conversations/details/query). Conversation details has all the metric(name,value, and emit_date).

    My SQL query is able to count the number of calls answered('tAnswered') for given time period for each queue, and the numbers always match with the purecloud UI report.

    For some reason numbers for calls abandoned(tAbandon) and offered('nOffered') do not match.

    Can someone please help here? Did someone tried creating reports for calls answered,offered,abandon for a queue from conversation detail data ?


    tim.smith | 2019-08-16 15:10:31 UTC | #2

    Customer data cannot be investigated via the developer forum. If you believe you're getting incorrect data, please open a case with PureCloud Care. That said, try doing a detail query and manually tabulating the counts to see how they add up. That usually explains discrepancies you may see.


    system | 2019-09-15 15:10:31 UTC | #3

    This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.


    This post was migrated from the old Developer Forum.

    ref: 5793