I would like to create a dashboard for long-term capacity planning.
We have a farm of servers, which usually are busy during the night (<=95% cpu) and not so busy during business hours (~20%). Therefore any graph with the default 1h aggregation will have high peaks and will look like "binary", either full load or no load with no trends visible (only the x-axis duration will vary).
What I would like to see is the cummulated load per day or maybe the average load over the full day on a graph which shows the last 12 months with one value per day.
Is that possible?
... View more