agent

Hello guys, I've been struggling lately to find a way to show up on a wallboard what was the availability of our agents during a day based on their timestamp statuses. I am using Cisco UCCX and I can get a report named Agent State Detail which provides me agent name, Time when status change...

Hi there, I'm trying to transfer data between 2x workbooks. I need to take the highlighted data from the below workbook (currently split between different 'agent' tabs) and consolidate that data into a second workbook where it is then split down further depending on what type of policy an agent...

Is there a macro or module out there that would parse agent strings? Just looking for Device Type, Operating System, Browser. For example: Mozilla/5.0 (iPad; CPU OS 9_3_5 like Mac OS X) AppleWebKit/601.1.46 (KHTML, like Gecko) Version/9.0 Mobile/13G36 Safari/601.1 Tablet, iOS 9.3.5, Safari...

Hi Guys, My idea is to read the values from the Excel file and list them in ListBox. The idea is a user reads all currently Open tickets that are stored in a workbook and has them displayed in the list box. Then selects an item he'd like to close and just clicks 'Close' button - the status in...

I have a data source which has 1 row per call. i have columns which have agent name, routing skill, and call disposition. I need each agent as a row with routing skill underneath. (no problem) Then I have the count of Calls for each skill and a subtotal (again, no problem). Here's the...

The pivot table below is counting the number of tickets handled by agents on each row (by counting the reference numbers that appear in the data set against each name on any given day). Where the corresponding date is blank in the pivot table the assumption is the agent didn't work. I'd like...

I've got a dataset that lists records of resolved tickets by date and agent name (as well as a few other criteria). I created a pivot table that has the agent names in the row field and the resolution dates in the column field so I have a daily count of number of resolved calls by agent as well...

Hi, i am mystified and willing to test anything in order to solve this. All WAG's will be gratefully accepted! I have a LotusScript agent that runs as a scheduled agent on a Domino (Lotus Notes) server. It creates a report as an Excel spreadsheet, saves it, and attaches it to a Notes document...

Hi experts, I searched the whole forum for this type of query and found no solution (or I may not be using the correct keywords). Kindly help me create a formula wherein whenever I add a sales entry from a certain client in sheet 2 (sales worksheet), the respective agent's name will...