Creating a "summary graph"

[tbushnel]

My director is interested in a summary graph that shows the average utilization of our entire server farm at any given time. I have individual graphs for each server, but I want to have a graph that shows the average from all the other graphs.

The data's already been collected so I only need to perform calculations on this data, but don't know how to do it. The CDEF's seem to only work when using data from the current graph. I'd rather not have a legend that shows all of the individual servers on this graph as it's already on the other graphs. I simply want to pull the data from the rra's and show a graphical representation of the average. Does anyone know the best way to go about doing this. I'd even consider writing a script that pulls the data from the rra's, performs the calculation and dumps back into a separate RRA, but am not sure how to do this. I'd appreciate any suggestions/advice.

todd

[lepermime]

Here is my post and the response I got from someone.

http://www.raxnet.net/board/viewtopic.p ... highlight=

[tbushnel]

Thanks, but I'd much rather have a graph that only had gprints and an area graph of the summary. I have 30+ servers in a farm, each with their own graph. I'd rather not add gprints for all of those before averaging all the data. Unfortunately, it doesn't look like the CDEF's must get their values from that already displayed on the graph.

[jvanhambelgium]

hi tbushnel,

If you create a graph and input your 30 datasource-items, take "AREA" for the first and all other 29 as STACK and use the same color then you have a total-graph representing you 30 datasources....I also use this to make totals of parameters on 2 different POP's having each there own equipment.

You don't need to place any GPRINTS on the bottom. It can be just the graph and nothing more.

Regards,
Jan