Aggregate different data sources and divide them

[luthing]

Hello everyone,

I would like to have a graph that calculates and traces a simple line based on the following formula:

Code: Select all

sum(traffic_in_average1,traffic_in_average2...) / sum(client_count1,client_count2....)

I have about 20 sources of traffic_in data and 160+ sources of client_count data.

How can I have, in the same graph, 2 sums of different data sources and divide them up?

I tried with the reportit plugin, but it cannot create new datasources by the way...


Any help would be much appreciated
Cheers

[TheWitness]

How big is the install?

[luthing]

Sorry, I don't totally get your question.
Do you want the server specs ?

[TheWitness]

Number of Graphs, Data Sources, Devices. If the install is not too large, you can enable Data Source Statistics and then create a Data Input method that queries those tables performing the summing and then simply Graph things that way. But after a second read, it might make sense to be able to do something like what other monitoring systems are allowing, which is to tag an interface or device and then aggregate based upon the tag, or have a different Graph Templating engine that allows for that aggregation automatically via a tag or query.

I think of these things often. I really thing that Data Source Stats will be a great source of having merge type Data Input Method, but I also think that having a different way of creating aggregates also makes sense. The original design was done by @Gandalf and then by me several years ago, and could use a refresh.