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
Store

Custom Chart - Sum instead of Average

I have a Counter based UnDP I'm charting using the 'Custom Chart' widget.

It plots just fine, the issue occurs when I zoom out by changing the displayed date range and the granularity of the Time axis (x-axis) changes from 1 min (the polling rate I'm using), to something larger (e.g. 2 mins). The Custom Chart seems to be hardcoded to combine values by averaging them, when I want them to be sum'd instead.

Does anyone know if there is a way around this? I'm hoping I've missed a configuration option, or there's another widget or way of doing things to get a sum instead of an average.

In the images below, see how the displayed value is halved because the Time interval on the bottom axis changes from 1 min to 2 mins, and the polled value it's combined with is a 0.

1 Min Intervals on the chart:

2 Min Intervals on the chart:

2 Min Intervals on the chart

The SWQL code is as follows, I'm plotting the RawStatus value as this contains the Delta between the Current polled value and the Previous.

SELECT DateTime, RawStatus, RowID
FROM Orion.NPM.CustomPollerStatistics
WHERE CustomPollerAssignmentID = ''
AND RowID = '2'

Find more posts tagged with

Accepted answers

mesverrum

The behavior where Orion charts average data points any time the time scale goes wider doesn't have any built in way to manage it.

If you can live with having a hard coded time span then one trick you can do is to bucketize the timestamps in your SWQL directly. Basically you pick your unit of time and set the query to just create the data set you want and don't give orion the option to mess with it. This should be a workable syntax for 5 minute buckets

SELECT ADDMINUTE(MINUTEDIFF('2000', cps.DateTime) / 5 * 5, '2000') as DATE, sum(RawStatus) as SUMS, RowID
FROM Orion.NPM.CustomPollerStatistics cps
WHERE CustomPollerAssignmentID = '<redacted>'
AND RowID = '2'
GROUP BY ADDMINUTE(MINUTEDIFF('2000', cps.DateTime) / 5 * 5, '2000'), rowid

Here's an old thread where I talked about creating time buckets for a very similar request.

thwack.solarwinds.com/.../swql-query-to-group-results-in-increments-of-5-minutes

All comments

adam.beedell

I think on a perfstack chart, the "linear" transform does what you want

On classic dashes I think something in SAM with trackdifference enables acts like that but I dont know how you get there from where you are

swistoni

Thanks for the reply

Unfortunately it appears I can't plot table based UnDPs on perfstack. I could get around that by creating a UnDPs for the specific rows I wan't to pull back, quite a lot of work and not really scalable. But an option at least.

Found this regarding the 'linear' transform, sounds more like a least squares fit than a summation , I'll have to take a look.

Linear Regression - Shows the overall linear trend of the charted data. The slope of the linear trend indicates the overall trend of the data in the charted timeframe. Linear Regression is useful for showing if a noisy set of data is trending up, trending down, or remaining constant.

adam.beedell

I whacked up a test or two that looked ok but didnt do the math, so yeah you might be right

There's a lot of classic graph-type things, and I think many are considered a bit depreciated, but there is a table somewhere (I posted on thwack about it, but long, long ago and I'm not sure i'd find it again) listing off the available charts, good chance something does it

It's definitely reportable in the worst-case, but I imagine you'd want something dynamic

UNDP to perfstack is, I believe, on the feature request list and on the todo with the devs, I'm sure it's come up at events. If the Linear transform doesnt add then that's probably worth a FR on it's own as I'm sure it's not the craziest thing to add.

You can query a UNDP with an API poller which turns it into a perfstack compatible metric, but that's not something to apply across the board

mesverrum

The behavior where Orion charts average data points any time the time scale goes wider doesn't have any built in way to manage it.

Here's an old thread where I talked about creating time buckets for a very similar request.

thwack.solarwinds.com/.../swql-query-to-group-results-in-increments-of-5-minutes

swistoni

Thanks, UnDPs that pull scaler (single valued) OIDs do plot on Perfstack, it's the the UnDPs that pull back Tables that don't.

"You can query a UNDP with an API poller which turns it into a perfstack compatible metric, but that's not something to apply across the board"

That's a creative idea, I can think of quite a few different application for that technique, thanks

swistoni

Thank you, I think this is the approach I will take.

Atash31777

This was a helpful one