Morning all,
I am looking to convert the below cross-tab table into a graph however I'm having real problems when I start to introduce multiple Servers into the equation as I can't show Computer_Name and Disk_ID in the legend. It would appear that the best way to do this would be to try and concatenate the Computer_Name and Disk_ID and have 1 column for each... is this possible or is there a better way?
|
Computer_Name_1
|
Disk_ID_1
|
Disk_ID_2
|
01/01/2014 00:00
|
50
|
60
|
01/01/2014 01:05
|
51
|
60
|
01/01/2014 01:10
|
51
|
60
|
01/01/2014 01:15
|
68
|
60
|