I've created a custom report based on the "Detailed Call by Call CCDR Report" which lists all incoming calls to applications. On this report a number of records have the queue_time field has blank. These are calls that were abandoned before it reached the queue. When grouping by this queue_time these records show with a queue_time of "undefined".
We'd like to have all these calls with a blank queue_time highlighted in colour on the report using a threshold. But the threshold screens don't allow us to enter "undefined", "blank" or "null". They only accept a decimal format.
How can I set up a threshold that highlights these records with a blank field?
Regardless of your custom report, you've already proven that a threshold can only check for a user populated value? Then I think you'll need to have your custom report change all non-positive integer values to -1, and then use that as your threshold value. Is that possible for you to do?
E.g., SELECT CASE WHEN queue_time IS NULL THEN -1 WHEN queue_time = "" THEN -1 WHEN queue_time = "undefined" THEN -1 ELSE queue_time END FROM <tablename> WHERE <clause>
Cisco Finesse Not Ready - Call Overlap status is very a very common issue seen on Finesse desktop. Agents miss two calls and they are put in Not Ready - Call Overlap status. This is very likely related to CVP server and it's unreachabl...
Lab 1: Cisco Meeting Server Standalone CertificatesLab 2: Cisco Meeting Server Cluster Certificates with Multi-SANLab 3: Multiple Certificates with Multiple CA ServersLab 4: Cisco Meeting Server Cluster Certificates Advanced ScenarioLab 5: Streamer Servic...
Certificates are the first step to deploy Cisco Meeting Server, preparing certificate are very important to enable different services. As a VOIP administrator, mastering the concept of certificates is unavoidable
Using multiple CA servers, instead of a si...
I just finished to write a comprehensive certificates preparation for Cisco Meeting Server Clustering. Through 60 pages I explained in detail, how to create certificates for database cluster, callbridge cluster, certificate chain for webbridge3, certifica...