Graphing change in continously growing counters

[centsi]

Hi all.

I've been happily graphing our support system to show how many open cases exist and of what type etc, and it works nicely using net-snmp and sql queries.

We would now however like to graph resolved cases, which of course is an ever increasing number.

I'd like to see how many cases have been resolved in an hour and then total up that figure when viewed over longer time periods.

I can fairly easily poll for cases resolved over a fixed time period in relation to the current time, but the question is how to total up and graph those figures over the longer time periods.

I thought the bandwidth totalling function might work, but a) I think this only works for displaying numbers on the graph, not actually graphing the totalled number and b) it seems to always include the word "bytes" on the end.

The other option, would be to poll the all time number of resolved cases and then somehow graph the difference between the start and end of each time period, but I don't really have any idea how to achieve that

Does anyone have any ideas or tips on how this might be possible?

Thanks a lot in advance.

Lawrence.

[gandalf]

Graphing increasing numbers is a goal of the COUNTER ds type. This will show you the difference between consecutive intervals
R.