Demosthenes&Locke
Board Regular
- Joined
- May 11, 2010
- Messages
- 93
I have a series of data that I am unable to graph correctly.
How can I graph this so that it is useful? I have tried several different ways and this data is actually tabulated from another list arranged as follows:
If anyone has any suggestion as to how to graph this, or arrange the data so it can be graphed easily, or any info as to how to get this in a useful format please let me know, I am under the gun and the report is due tomorrow and I've been floundering at this for a while now. The pivoting of the original data ends up with (trying counting) a 1 under each date header and a count of all the rest of the dates per category summed up at the end
Code:
Building Status 01/01/11 03/17/11 04/15/11
Admin Added 4 1 2
Admin Deleted 0 2 2
Admin ReAdded 0 0 1
Tower1 Added 5 4 3
Tower1 Deleted 0 2 1
Tower1 ReAdded 0 0 2
...
There are actually 6 buildings, 4 status states, and 30 different non-sequential
dates.How can I graph this so that it is useful? I have tried several different ways and this data is actually tabulated from another list arranged as follows:
Code:
Key Building Added Deleted ReAdded
0001 Admin 01/01/11 03/17/11 04/15/11
0002 Admin 01/01/11 04/15/11
0003 Admin 01/01/11 04/15/11
0004 Admin 01/01/11 03/17/11
0005 Tower1 01/01/11 03/17/11 04/15/11
0006 Tower1 01/01/11 03/17/11 04/15/11
0007 Tower1 01/01/11
0008 Tower1 01/01/11
0009 Tower1 01/01/11
0010 Admin 03/17/11
...
There are additional columns, and I would like to be able to filter the graph
based on the additional columns, which is why I was trying to use a pivot
table/graph, but it doesn't seem to want to come out the way I need it.If anyone has any suggestion as to how to graph this, or arrange the data so it can be graphed easily, or any info as to how to get this in a useful format please let me know, I am under the gun and the report is due tomorrow and I've been floundering at this for a while now. The pivoting of the original data ends up with (trying counting) a 1 under each date header and a count of all the rest of the dates per category summed up at the end
Code:
Dates
Data 01/01/11 ... (blank)
Count of Added 1 ... 154
Count of Deleted 0 ... 331
Count of ReAdded 0 ... 64
...
Count of added should be equal to 9 but instead for every occurrance
it only holds a 1 and the rest are shuffled off to blank.
A sumif statement brings it to the right place, which is where I got the
second (top) layout of information. (the only problem is I can't filter
stuff like I need to)
