Is it possible to have realtime & historical columns in custom dashboard??

Version 1
    This document was generated from CDN thread

    Created by: Sulabh Patel on 07-11-2011 01:17:56 PM
    CUIC 8.5.2
    We've created a "real time" customized CUIC report for customer which is comprised of following columns - Calls Waiting, Agents Available, Abandoned, Longest Call Waiting. All these columns display realtime data from the awdb.
     
    The customer is requesting that the 'Abandoned' column should be showing cumulative abandoned calls (i.e. historical data) for a particular period or day. Is it even possible to combine realtime and historical columns in a single report??
     
    Any help/suggestions are appreciated.
     
    Thanks,
    Sulabh

    Subject: RE: Is it possible to have realtime & historical columns in custom dashboar
    Replied by: ED VILLARREAL on 08-11-2011 10:42:51 AM
    This can be done, but it requires that you create a new report definition that joins the real time and historical tables based upon a common ID.  One caveat is that the historical data will only be refreshed based upon the configured interval, 15 or 30 minutes.