About sarbarnes

sarbarnes · 02-19-2016

I am working with a customer who reports on Abandoned call level in detail. In Simplistic terms, when running the Skill group Historical report we are seeing 24 calls abandoned in SL Aban column and 38 in the Aband calls column. Whilst those 2 column...

sarbarnes · 02-01-2016

Team, I have taken a standard Reason code report, which I show as columns of the time for each reason code by Agent. I have a customer who want to see Total Call time (Talk/Active), % Call time & number of calls handled, all within the same report. T...

sarbarnes · 01-27-2016

I have created a report which I have just imported into a customer site This is the Substring i have created to separate out data that is being shown in the Variables within the Termination Call Detail reportTCD.Variable2 as MIDandStatus,TCD.Variable...

sarbarnes · 10-27-2015

I wonder if anyone can help, I have been asked to provide a report that takes multiple pieces of data that is being pushed into the Call variable 5 as a string, and then be able to report on each of the separate pieces of information within a report....

sarbarnes · 07-13-2015

I have created a report based on ANI for a customer who wants to understand whether a customer has called in more than once. However although I can run it properly and bring back data, however when I add in the DateTime field, it doesn't bring back a...

sarbarnes · 02-02-2016

Thanks Jameson, I will be able to get on the customers system tomorrow so will look to try what you have suggested, Sarah

sarbarnes · 10-28-2015

Thanks Jack, I have taken a brief look at this and it echos what has been written by Jameson, now I need to try it and see if I can get it to work.

sarbarnes · 10-28-2015

Thanks as always Jameson, that gives me something to think about and play around with

sarbarnes · 07-13-2015

Jameson, Forget the Agent part, I have removed that from the query, the key thing is that they can run it by Call Type, as the assumption is that they never got to an agent, hence they are calling back in.... I am actually thinking that the customer ...

sarbarnes · 07-13-2015

James, I get data from that AB query and you can run it by date, however you do not have a datetime field to group on - which is what the customer wants, hence my question :-) Basically if I run it for today and a customer called that call type 3 tim...

Member Since	‎12-12-2012 08:08 AM
Date Last Visited	‎03-26-2019 05:01 PM
Posts	89
Total Helpful Votes Received	13

User Statistics

User Activity

Abandoned calls - Seen in the SG Ans/Aband report but not in the SG His report

Calls Handled & % Talk time as part of a Reason code report

Database Error showing 537 message Invalid length parameter passed to the LEFT or SUBSTRING

Splitting data into different columns that is shown as a string in 1 Call Variable field

Creation of Repeat Incoming Caller report

Re: Database Error showing 537 message Invalid length parameter passed to the LEFT or SUBSTRING

Re: Splitting data into different columns that is shown as a string in 1 Call Variable field

Re: Splitting data into different columns that is shown as a string in 1 Call Variable field

Re: Creation of Repeat Incoming Caller report

Re: Creation of Repeat Incoming Caller report