Generate a report that compares the support efficiency

**sravanthi.boggaram** · 11-08-2011, 01:22 AM

I need to generate a report that compares the support efficiency for the following months:

Oct - Dec - 2010
Jan - Nov - 2011 to be sorted month-wise

This attachment has 2 important fields i.e.
Date Created - The date when the ticket was opened
Last Modified – The date when the ticket was closed with solution

i.e create a column for age showing the no. of days for each ticket to be closed (Last Modified minus Date Created)

The report may be in the following format:

For Example: For the month of November 2011, the report shall be:

Month: Nov 2011
Total Ticket Closed: 2
Total Resolution Time: (2+1) = 3
Average Resolution time: (Total Resolution Time)/( Total Ticket) = 1.5

cheers
Sravanthi

**arlu1201** · 11-08-2011, 03:25 AM

Have a quick question -
What about line number 7 which started in october but ended in november, for which month will it be counted?

Also, will it work if the output is given in columnar form - like
Month - Total Ticket Closed - Total Resolution Time - Avg Resolution Time

**sravanthi.boggaram** · 11-08-2011, 03:50 AM

the "created date" is only counted (in this case October is taken)..

**sravanthi.boggaram** · 11-08-2011, 04:01 AM

Yes.. the report could be in columnar form also!!

**arlu1201** · 11-08-2011, 04:06 AM

Great - try this code and let me know -

Please Login or Register  to view this content.

Copy this code into a module.

**sravanthi.boggaram** · 11-08-2011, 05:29 AM

the output i get is according to the attachment..

can the report be generated in a new sheet (comprehensively for each month separately instead of repeating for each row)?

In the existing sheet "count" alone can be added. Report in columnar form (i.e., Month
Total Ticket Closed, Total Resolution Time, Average Resolution time) generated in new sheet.

I would like to have this data for all the said months. Nov 2011 can be ignored and just until Oct 2011 from Oct 2010.

**sravanthi.boggaram** · 11-08-2011, 05:35 AM

For example:
Month Total Ticket Closed Total Resolution Time Average Resolution time
Oct 2010 10 23 2.3
Nov 2010 12 24 2
.
.
. and so on

**arlu1201** · 11-08-2011, 06:33 AM

I am surprised that you are getting it repeated on several rows as i am getting it in comprehensive format. I have attached the output i receive.

I have changed the code to move the data to another tab. This is the updated code -

Please Login or Register  to view this content.

**arlu1201** · 11-08-2011, 06:33 AM

If you still get it repeated, attach the workbook and let me check.

**sravanthi.boggaram** · 11-08-2011, 06:48 AM

When I run the macro the get this error message box "Run time error".. i clicked "debug".. the output (as in the attachment) displays only the Month column for all rows(other columns are not there)..

**sravanthi.boggaram** · 11-08-2011, 06:54 AM

I would like to have this report for Oct 2010, Nov 2010, Dec 2010, Jan 2011, Feb 2011... till Oct2011.
Nov 2011 can be ignored.

**arlu1201** · 11-08-2011, 07:11 AM

Oops i understand. You are using excel 2003 and i gave you a part of the code which is compatible with 2007. I will change it and get back to you soon.

**sravanthi.boggaram** · 11-08-2011, 07:15 AM

Much Appreciated.. Thanks a ton!!

**arlu1201** · 11-08-2011, 10:34 AM

Try this code -

Please Login or Register  to view this content.

**sravanthi.boggaram** · 11-08-2011, 11:40 PM

Works like a gem!!! Thank u so much arlu!! Will get back to u if I have doubts.. thank u once again

**sravanthi.boggaram** · 11-09-2011, 12:34 AM

Hey arlu.. In sheet2.. the months should be in the reverse order right??

**sravanthi.boggaram** · 11-09-2011, 01:29 AM

Hi arlu.. The month column in "Sheet2" should be in reverse order right??

**arlu1201** · 11-16-2011, 07:11 AM

Hey sorry i was on vacation for a wk...is this issue solved?

Generate a report that compares the support efficiency

LinkBack

Thread Tools

Rate This Thread

Display

Generate a report that compares the support efficiency

Re: Generate a report that compares the support efficiency

Re: Generate a report that compares the support efficiency

Re: Generate a report that compares the support efficiency

Re: Generate a report that compares the support efficiency

Re: Generate a report that compares the support efficiency

Re: Generate a report that compares the support efficiency

Re: Generate a report that compares the support efficiency

Re: Generate a report that compares the support efficiency

Re: Generate a report that compares the support efficiency

Re: Generate a report that compares the support efficiency

Re: Generate a report that compares the support efficiency

Re: Generate a report that compares the support efficiency

Re: Generate a report that compares the support efficiency

Re: Generate a report that compares the support efficiency

Re: Generate a report that compares the support efficiency

Re: Generate a report that compares the support efficiency

Re: Generate a report that compares the support efficiency

Thread Information

Users Browsing this Thread

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions