Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How can I combine Realtime and Historical stats in a custom report?

Status
Not open for further replies.

mcmillb

Technical User
Dec 11, 2002
6
GB
We are installing a new wallboard system. The wallboard server logs in via telnet and runs a report which displays the stats refreshing every 3 seconds. The server then reads the stats from the report display and sticks it on the wallboard.

I am writing a custom report for the wallboards and I want to display an accurate stat for abandoned calls and ACD calls today for a skill/split.

This would logically (to my mind) be the sum of the hskill.ACDCALLS for the day (previous intervals) added to the cskill.ACDCALLS (current interval), except that custom reports do not allow you to mix realtime and historical tables in one report.

Is there any other way to achieve this, another table I could read, etc.

Any ideas?

Billy McMillan
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top