Community
- Command Central
- MVP Program
- Monthly Mission
- Blogs
- Groups
- Events
- Media Vault
Products
- Observability
- Network Management
- Application Management
- IT Security
- IT Service Management
- System Management
- Database Management
Content Exchange
- SolarWinds Platform
- Server & Application Monitor
- Database Performance Analyzer
- Server Configuration Monitor
- Network Performance Monitor
- Network Configuration Manager
- SQL Sentry
- Web Help Desk
Free Tools & Trials

Custom chart with individual interfaces and a combined total on one chart

I'm trying to create a custom chart that has the bandwidth utilization average % of 2 individual interfaces located on two different routers, and on that same chart, have both interfaces' utilization combined and represented as one line, into one graph. I've been able to produce the charts individually, but how can i combine these two to present all this data on one graph? The two pictures below show "Custom Chart", which has the two interfaces i'm curious about grouped together, the "ISP_Circuit", shows the individual interfaces (and has one additional interface that i don't need the stats on).

grouped interfaces.JPG independent interfaces.JPG

Find more posts tagged with

Accepted answers

All comments

bleearg13

I do this by creating a Multiple Object Chart and adding the interfaces I want to it. You can then also choose to show the sum. The only downside to this is that the graph that is created is not interactive like the default traffic graphs.

sonis718

custom map in atlas?

bleearg13

Sorry to respond a second time, but your original method of using the Custom Chart appears to do this. There's an option in the resource called "Show the sum of all data series":

Is this option not available to you in your graph? Here's an example of what it looks like in mine:

The dotted black line is the sum. Also, I want to thank you because I've been using the method I described in my earlier response to graph multiple objects and I've hated it because the graphs are so "static" and don't look nearly as nice as the Custom Chart. I had no idea this resource was even available so I spent most of yesterday converting all my graphs!

jere557

Thanks bleearg13! However, I was hoping to get a combined average and not the sum. We're load balancing through two interfaces on two different nodes. If we have one interface at 100% utilization and another at 10% utilization, we'd like the graph to show that it's at 55%, and not 110%. The sum is helpful though, and i think it's the best option that we can use now. I'm trying to figure out an SQL query to add the two averages together, and display that but my sql knife is dull and needs to be sharpened more. I'll let you know here if/when i get it. I'm on the right track with a co-worker, just trying to learn sql throughout this process, and not ask for a handout query.

bleearg13

Ah, I see - I misunderstood. I'm not sure how you could show the average between the two ports without maybe doing a UnDP of the data and then a transform. Then again, I may be overcomplicating things - I do tend to do that.