Afternoon all,
I have tried many different method to make this graph work but it seems impossible!! I have a number of servers, which each have multiple Disk ID's, and at the moment the best way I've found to represent this is like the below; where the date is merged over the Disk_ID's (A & B), Server 1 and Server 2 in different columns and the disk_utilisation_% being in the middle as a calculated average figure for that day.
When I graph this I can only chose two selection points; The Date has to be one and the other either Server_Name or Disk_ID. Here lies the problem, I want to report on Server_Name AND Disk_ID so I can graph more than 1 server at a time!! So I could have a graph with 5 servers, for example, all the dates in the report and the legend would show which line colour matches to which server/disk combination.... am I asking too much or am I trying to achieve this using a really complicated method when there is something much easier?
Server 1 Server 2
01/04/2014 A 85 70
B 70 74
02/04/2014 A 86 74
B 90 75
03/04/2014 A 83 80
B 86 79