Search results for query: *

Yeah, I need to know a count of agents re-assigned. I may be answering my own question here, but is it as simple as using a skillset report and doing a count of the agents with the re-assigned skillset? I think it is me being a bit thick. Regards Phil

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

The simplest solutions are sometimes the best. Thanks. Worked a treat !!!

Here you gohttp://david.intelligentmi.com/tek.xls

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...

Thought of that one too. As my references were over several columns on each formula, it would have taken me just as long to do it that way. The cut and paste solution worked ok though. Thanks anyway Phil

I can't beleive I have been using excel for 10 years & I didn't know that cutting and pasting would keep the formulas static. Now I know this I have found an alternitive solution : Copy the full column into a sperate sheet on the same workbook making sure I copy into the same column on the new...

I need to copy them, however even if I cut them I would still be in the same situation, as it would still move the reference on by one cell to the right. Any other thoughts

if I copy & paste the formula (Sum(C1:C2)) from column a to column b then the formula changes to Sum(D1:D2). I need the formula to show (Sum(C1:C2)) after it has been copied, however I need to do this for over 400 formulas (in one column), so I need to lock all the formulas before copying them...

This is for Excel. Quite important factor missed.

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

So would this solution work without a dialler If so, how? Cheers Phil

The real time displays each time a DN out call is active. Why can't the historical reports reflect this? Phil

I have looked on the agent performance table. The Stat DNOutExtCalls is the number of attempts. Which one in number answered? 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...