Search results for query: *

Can anyone tell me how I can create a report in v5 to show skillset assignments used. I have a skillset report however, I am not sure if this shows me the assignments used also. Regards Phil

I have a chart which has week commencing on the x axis. When I show this as a bar chart the width of the bar is too thin. I have found this is due to the base unit being set to days, rather than weeks, (therefore the graph makes space for 7 days between each bar)however there is no option to...

I have a pivot table which has data by day / Brand/ sub type. Then the data shown is a % of the total. Is it possible to use the sub total instead of the grand total to get 100%. Current e.g 01/03/07 / Brand /Sales / 100 / 25% 01/03/07 / Brand / Marketing / 100 / 25% Sub Total...

I have create a pivot table which has the dates from a data sheet. From time to time I miss a days data & have to re-import in into a sheet at a later date. Once I Import the data, the pivot table shows the data at the bottom, despite being in date order on the sheet. Does anyone know how to...

I have a document I send every 2 hours by e-mail. As the doc is quite large (1mb) I want to make sure it deletes after 2 hours (if unread). I have being using the expiry function to do this, which works fine, however it would be great if I could create a from in outlook which can do this...

I have a column of formulas (all different) which reference a seperate worksheet. I need to copy all the formulas in the column and paste them into a seperate column but keeping the same referenced cells. I understand I can lock the formulas individually, however there are 432 formulas to...

Can anyone tell me how I can create a report which shows all DNIS by Application. Is there a link or table I can use so I can create a Crystal report. I can acceess the application stat table or the DNIS table, however I don't know how to link them. Cheers Phil

We have a split centre (inbound / outbound) . The reporting works fine for inbound, however I need to get the number of connections for the outbound attempts. Is this possible as our solution only gives the number of attempts? We use v.5 Many thanks Phil

I want to create a chart which gives the average number of calls answered over a 4 week period by time of day. I can group the graphto show a seperate chart for each day or I can group the graph by time of day. How do I create a single graph which overlays the answered calls for the time of...

I want to create a task that can be sent to more than 1 person (as they both do the same job. However once this task is assigned I get a message stating 'updates will not be tracked as it assigned to more than one person.' Does anyone know a way arond this as I need to be kept informed as to...

I currently have a pivot table showing the agent names(Rows) the skills they have (Columns) and the level of skill they are on (Data). There are some agents which all have the same skills & levels. Is there a way I can group these together on a pivot table. I use v.8.5 Cheers Phil

I currently have a solution which uses a NR reason code for collating data on Wrap time. Unfortunately our data feed to WFM uses the Wrap (Break time) for calculating this (I think). Please can anyone confirm if Wrap time (Break Time) is also counted within Not Ready Time? Also if an agent...

I have configured telsets to utilise NR Codes. This works fine in Historical reporting but not in the real time display. I have 6 codes ACW BREAK MEETIN COACHING TRAINING PERSONAL For some reason 'Break' will not display in real time. Initally I thought it was due to using Code '1', so I...

I have a spreadsheet which has data over a monthly period by 15 minute intervals (for 24 hours). I have created a lookup which determines the open / close times for the data. This works fine during normal open hours, however if there is a special day (i.e. bank Holiday) where the open times...

My data is collected in 15 minute intervals. I can group by hour, minute, seconds. Is there any way I can group the data by 30 minute intervals? Cheers Phil Crystal v.8.5

Our Telecoms have created a solution in our cc to make the experienced agents wait 20 secs before taking a novice call, thus allowing time for a novice agent to become available. This has been done by creating a second skillset from the same application which will q to both skillsets...

I have a formula for working out the week number : - Datepart ("ww",{Stat.Timestamp}) This works fine, except it uses Sunday as the first day of the week. How can I use Monday instead? Thanks Phil Crystal v8.5

I have a graph by interval & I would like to show a seperate graph on each day (including all intervals that day). I need a report which shows 7 graphs, each with interval data. I can create the graph fine & put it into a header or group (by day), however I can't get it to show by interval...

I am trying to create a custom report in Crystal by Application. The challenge I have is to reflect the open times of each department (each are different). The script in symposium sends the call to a closed message on time of day, (this is a single global message). My question is this: Is...

I have a report for a call centre. The report shows call vols for the day by department. There are 3 departments all of which have different open times. Although I can set a parameter to filter one of the open hours, how can I show each departments call stats while they are open? I need this...