434,998 Members | 2,903 Online
Need help? Post your question and get tips & solutions from a community of 434,998 IT Pros & Developers. It's quick & easy.

# Help with chart

 P: n/a I have a table with amongst others 2 fields: DateIn and DateOut. The idea is to make a chart that shows the average number of days it takes for a request to be answered. I'm planning to make a linechart with on the x-axis the months (starting with the current month and ending 11 months later) and on the y-axis the average number of days (DateOut minus DateIn). So the chart will show the average number of days per month. How would I go about this? Which outputfields do I need in my table/query for my chart? It's possible that there are 100 records for January and just 20 for February. Is there a way to make that visible in the same chart? Thanks in advance for any help. john Jun 8 '07 #1
7 Replies

 P: n/a "John"

 P: n/a Thanks Bob, See inline: Some general responses to your info. 1) Do you mean starting with the current month and ending 11 months earlier? It's hard to predict the future. :-) You're right, that was what I meant. 2) if there are 100 records in January the average will be a single number, same as for 20 rows in February. True, but the number of records involved per month would help to interpret the figures. For instance, it could indicate that a month with a great less number of requests, has a lower duration average. If the number of requests for 2 particular months are the same but there is a big difference between the average duration times of those months, that would be something to look into. Any idea on how to incorporate that into the chart? Now some practtical information. Create a query with year(DateIn)*100+month(datein)as a column. and datediff("d",datein,nz(dateout,date()) as a second column. the third column would contain any field which would have non- blanks. Turn this into a Summary query, group by the first field, average the second, and count the third. You can also add a criteria to the first column with the expression (year(date()-1)*100 +month(date() This will give you 12 rows, with the period, the average Great! thanks, john "Bob Quintal" I have a table with amongst others 2 fields: DateIn andDateOut. The idea is to make a chart that shows the averagenumber of days it takes for a request to be answered. I'mplanning to make a linechart with on the x-axis the months(starting with the current month and ending 11 months later)and on the y-axis the average number of days (DateOut minusDateIn). So the chart will show the average number of days permonth.How would I go about this?Which outputfields do I need in my table/query for my chart?It's possible that there are 100 records for January and just20 for February. Is there a way to make that visible in thesame chart?Thanks in advance for any help.john Some general responses to your info. 1) Do you mean starting with the current month and ending 11 months earlier? It's hard to predict the future. 2) if there are 100 records in January the average will be a single number, same as for 20 rows in February. Now some practtical information. Create a query with year(DateIn)*100+month(datein)as a column. and datediff("d",datein,nz(dateout,date()) as a second column. the third column would contain any field which would have non- blanks. Turn this into a Summary query, group by the first field, average the second, and count the third. You can also add a criteria to the first column with the expression (year(date()-1)*100 +month(date() This will give you 12 rows, with the period, the average duration and the number of rows making that average. Plot the period on the X axis, and either or both other columns on the Y azis. -- Bob Quintal PA is y I've altered my email address. -- Posted via a free Usenet account from http://www.teranews.com Jun 9 '07 #3