Help - Reporting / Graphing....

  • Thread starter Thread starter MrAlMackay
  • Start date Start date
M

MrAlMackay

I need to be able to prepare daily reports/graphs based on data as per below.

This data changes on a daily basis and obviously the graph needs to be able to
accomodate new months as and when we enter into a new month.

I wondered whether this could be done via a pivot table, however current
attempts have not got the desired result.

ID Team Incident Raised Date
IL0000001 Integration 13/02/2001
IL0000002 Program Office 12/02/2002
IL0000003 Technical 16/02/2001
IL0000004 Program Office 12/02/2002
IL0000005 Technical 16/02/2002
IL0000006 Technical 27/02/2002
IL0000007 Accounting 12/03/2001
IL0000008 MM 13/03/2001
IL0000009 MM 14/03/2001
IL0000010 SD 14/03/2001

As you can see from the sample data above (this is over 1800 records
currently!, but extract of this is as above) - the dates are in no order. What
I also want is to sum by month / year, so therefore below would provide an
example of what the above would need to sum and therefore I can graph on these
sums:


Team: Feb 2001 March 2001 Feb 2002
Integration 1
Program Office 2
Technical 1 2
Accounting 1
MM 2
SD 1

Really appreciate any help that anyone can offer.

Many Thanks, Al ( (e-mail address removed) )
 
I might be able to assist as had to do something similar recently. I'd
suggest you need to add another column to your data which looks at the date
column and instead of returning the full date, just returns the month. This
would then allow you to do a pivot table of instances for a particular month
(you would put the new column header as the page or column). Incident type
would be the row and sum of incident type would be the data in the pivot
table.

This should give you what you want. The formula in the new column to just
give you the month would be :

=month(c1)

This will give the month in number format (e.g. 1 = Jan).

Let me know if this isn't quite what you're after.

Thanks,

Mitch
PS - did you used to work for BBS?
 
Back
Top