Search results for query: *

Hello, I have two excel workbooks. The first excel workbook has a cell with the following formula: =IFERROR(AVERAGE(B2:P3),"") The second workbook has the following formula to reference the first workbook. =IF('Workbook1!$R$2>79.9%,'Workbook1'!$R$2,"") I only want it to show the data if the...

I need to convert a time into numbers so that i can take those numbers and put them on a weighted average. I couldnt figure out how to do this easily so i came up with the following formula: =if(j2 = "12:50 AM",10,"") i want 1:00 AM to be the average mean and if its 12:50 to 1:00 AM i want it...

Ok i have scoured this site looking for a way to do this and i cant so im opening it up for discussion. I have 6 excel worksheets in a single workbook. The first 5 worksheets has data that pulls from other workbooks. I am trying to compile data across other workbooks into one single workbook...

I have a chart that shows the Average Cycle Time for a range of data. It works fine but for some reason anything outside the date range im selecting is being zero'd out and shows up on the graph as a zero. I cant figure out a way to get rid of it. I cant use the select tool because there are...

I am trying to a report that shows details about the surveys we send out for tickets that get created. The survey data is located on a specific table. I have created the following command to get this particular data as follows: SELECT CAST(call_req.persid AS nvarchar(30)) AS persid...

Is there a way to create a drop down list in Excel where the data in the list references another workbook?

Thanks to LBASS i have the following formula for calculating the average number of agents for each time frame. //{@accum} to be placed in the {@timeint} group footer: whileprintingrecords; numbervar int12to7; numbervar int7to5; numbervar cnt12to7; numbervar cnt7to5; if {@timeint} = "12:00 to...

what is the formula for counting the number of days during a specific date range. For example i want to count how many mondays there were during the date range so that i can take that number and use it to average out the number of calls we get on mondays.

I want to create a report that i can put in a date range, for example January to June. But i want to also break it down by time during each day. For example i do a report to see how many calls came through the ACD system. I put in a date range of 1/1/08 to 6/1/08. But i also want to see the...

I have a report that has a start date and end date that the user enters when running the report. I also have a crystal reports server that these reports reside on. Is there a way to to schedule a report to run that has a date range? The only thing i can do currently it seems is to have the...

I have a report that shows when someone logs in to a phone system each day. I want to take the total time they were logged in and divide it by the number of days they logged in for a given date range, and come up with an average. But im not sure how to do this in crystal because if i do a date...

It appears that crystal reports automatically selects a standard set of colors depending on the quantity of what it is showing. For example, for data 40,30,20,10 - 40 is always red on the chart, 30 always yellow and so forth. Is there a way so that the report chooses the color based on change...

I have a chart that shows current week and previous week's data. It is a vertical bar chart, on X axis it shows the following labels: Agent - Current Week Self Service - Current Week Agent - Previous Week Self Service - Previous Week The formula i use on change of for the graph is as follows...

I think i might be confusing myself but i have a command that looks like the following: call_req.open_date < DATEDIFF(second, '1/1/1970', {?02EndDate}+1) + (DATEDIFF(second, getutcdate(), GETDATE()) - DATEDIFF(second, getutcdate(), GETDATE()) * 2) I do the {?02EndDate}+1)...

I have a chart that shows data for a date range for a given week. How or what formula do i use to do another chart or a modification of the existing chart to also show the previous weeks data as well?

I have a table that i want to display on a report, it is the description of a ticket. So it would be a comment someone would add to a ticket. When i put the field in the report it looks like it is just grabbing at random one of the entries. For example, say i want to report on a ticket. That...

Thanks to IdoMillet i was able to figure out how to randomize the data but now i cant figure out how to make it so it picks 5 records for each group instead of just 5 records total. IdoMillet mentioned that you would have to apply it to "within group" logic but i am uncertain as to what this...

I have a report that shows ticket numbers and who created the calls. Is there a way to write a formula to take a random sample for each person that logged the ticket. I am trying to do an audit for the people that log the tickets. So i want to take 5 random tickets created by them. Is this...

I currently have a cross tab that shows names of individuals on the left, and then to the next tab to the right, it shows what kind of ticket it is, request or incident. Then i have each column broken down by date, and showing hte sum of hours worked for each ticket type. I want to be able to...

Is it possible to take a running total and divide it by another running total? and how would i be able to accomplish this?