Nectar: Month-to-date B/W totals do not make sense

[GlueGuy]

I created some reports that show month-to-date, last day, & last week bandwidth totals, but the month-to-date totals seem complete nonsense.

On the attached picture note that the month-to-date totals 13.2 GB, even though the date is only the 3rd of the month and the last week totals only 6 GB.

Or do I not understand what "this month" means?

[gandalf]

I assume, that this is due to the "NaN" handling.
Usually, totals are calculated by using the average and multiply it by the time stamp. In your case, this will include "predicting the future". In this case "NaN" implicitely is replace by average of the rest. Other may want to replace "NaN" by "0".
In fact, Cacti has it's own total calculation which I don't know by heart. It may even introduce a third "interpretation" of "NaN".
R.

[GlueGuy]

Ah. So the Nectar "This Month", is not really "Month to date" as I have assumed/interpreted, but rather more of a forecast for this month based on month-to-date usage?

So where would I change the NaN as "0" so that it would be actual month-to-date usage?

Or would it make more sense to re-label the current "This Month", to a "Forecast for this month"? As the forecast concept actually has real utility.

I guess I would like to be able to do both.

Is that an RFE?

[gandalf]

If "E" is "explanation", yes, maybe
R.

[GlueGuy]

LOL!

Request For Enhancement!

I actually find that the "forecast" nature of that is useful, as would some of our customers. However, actual usage to date is also useful.

[GlueGuy]

Getting goofy results even on daily and weekly reports (when I recognize that something is wrong). At least one customer is turning off his equipment part of the time, so I often get NaNs in the calculations (see below).

So the bps is getting a lot of NaN values, but the bandwidth totals get zeros. This has to be at least another problem? If a customer turns off his interface, how do I get it to insert a zero instead of NaN?

"Vertical Label:","'bits per second'"
"Start Date:","2013-02-11 07:20:00"
"End Date:","2013-02-11 15:20:00"
"Step:","300"
"Total Rows:","97"
"Graph ID:","8065"
"Host ID:","638"
"Summation:","Total In: 5.23 MB","|sum:auto:current:2:auto|"
"Summation:","Total Out: 18.29 MB","|sum:auto:current:2:auto|"
"Summation:","Total In+Out: 23.52 MB","|sum:auto:total:2:auto|"
""
"Date","Inbound","Outbound","Total In+Out"
"2013-02-11 07:20:00","1.2252228936e+02","0.0000000000e+00","1.2252228936e+02"
"2013-02-11 07:25:00","5.4464377308e+01","0.0000000000e+00","5.4464377308e+01"
"2013-02-11 07:30:00","1.2250494086e+02","0.0000000000e+00","1.2250494086e+02"
"2013-02-11 07:35:00","5.4090666667e+01","0.0000000000e+00","5.4090666667e+01"
"2013-02-11 07:40:00","1.2286164768e+02","0.0000000000e+00","1.2286164768e+02"
"2013-02-11 07:45:00","5.3335027038e+01","0.0000000000e+00","5.3335027038e+01"
"2013-02-11 07:50:00","1.2368599195e+02","0.0000000000e+00","1.2368599195e+02"
"2013-02-11 07:55:00","5.4295679291e+01","0.0000000000e+00","5.4295679291e+01"
"2013-02-11 08:00:00","1.2447092227e+02","0.0000000000e+00","1.2447092227e+02"
"2013-02-11 08:05:00","5.2515744397e+01","0.0000000000e+00","5.2515744397e+01"
"2013-02-11 08:10:00","1.2447092227e+02","0.0000000000e+00","1.2447092227e+02"
"2013-02-11 08:15:00","5.2515744397e+01","0.0000000000e+00","5.2515744397e+01"
"2013-02-11 08:20:00","1.2445489849e+02","0.0000000000e+00","1.2445489849e+02"
"2013-02-11 08:25:00","5.2239313945e+01","0.0000000000e+00","5.2239313945e+01"
"2013-02-11 08:30:00","1.2498758819e+02","0.0000000000e+00","1.2498758819e+02"
"2013-02-11 08:35:00","5.1892653422e+01","0.0000000000e+00","5.1892653422e+01"
"2013-02-11 08:40:00","1.2488593289e+02","0.0000000000e+00","1.2488593289e+02"
"2013-02-11 08:45:00","5.2951174534e+01","0.0000000000e+00","5.2951174534e+01"
"2013-02-11 08:50:00","1.2410759015e+02","0.0000000000e+00","1.2410759015e+02"
"2013-02-11 08:55:00","NaN","NaN","0.0000000000e+00"
"2013-02-11 09:00:00","NaN","NaN","0.0000000000e+00"
"2013-02-11 09:05:00","NaN","NaN","0.0000000000e+00"
"2013-02-11 09:10:00","4.1066666667e+01","0.0000000000e+00","4.1066666667e+01"
"2013-02-11 09:15:00","5.2132888889e+01","0.0000000000e+00","5.2132888889e+01"
"2013-02-11 09:20:00","1.2488593289e+02","0.0000000000e+00","1.2488593289e+02"
"2013-02-11 09:25:00","5.2951174534e+01","0.0000000000e+00","5.2951174534e+01"
"2013-02-11 09:30:00","1.2441677441e+02","0.0000000000e+00","1.2441677441e+02"
"2013-02-11 09:35:00","5.4409932741e+01","0.0000000000e+00","5.4409932741e+01"
"2013-02-11 09:40:00","1.2244914292e+02","0.0000000000e+00","1.2244914292e+02"
"2013-02-11 09:45:00","5.4591968308e+01","0.0000000000e+00","5.4591968308e+01"
"2013-02-11 09:50:00","NaN","NaN","0.0000000000e+00"
"2013-02-11 09:55:00","NaN","NaN","0.0000000000e+00"
"2013-02-11 10:00:00","NaN","NaN","0.0000000000e+00"
"2013-02-11 10:05:00","1.3420735786e+02","0.0000000000e+00","1.3420735786e+02"
"2013-02-11 10:10:00","1.2296869402e+02","0.0000000000e+00","1.2296869402e+02"
"2013-02-11 10:15:00","5.3910963455e+01","0.0000000000e+00","5.3910963455e+01"
"2013-02-11 10:20:00","1.2282210395e+02","0.0000000000e+00","1.2282210395e+02"
"2013-02-11 10:25:00","5.4217888963e+01","0.0000000000e+00","5.4217888963e+01"
"2013-02-11 10:30:00","1.2291334849e+02","0.0000000000e+00","1.2291334849e+02"
"2013-02-11 10:35:00","5.4409932741e+01","0.0000000000e+00","5.4409932741e+01"
"2013-02-11 10:40:00","1.2241529654e+02","0.0000000000e+00","1.2241529654e+02"
"2013-02-11 10:45:00","5.3893622670e+01","0.0000000000e+00","5.3893622670e+01"
"2013-02-11 10:50:00","1.2334591523e+02","0.0000000000e+00","1.2334591523e+02"
"2013-02-11 10:55:00","5.3640751441e+01","0.0000000000e+00","5.3640751441e+01"
"2013-02-11 11:00:00","1.2334591523e+02","0.0000000000e+00","1.2334591523e+02"
"2013-02-11 11:05:00","5.3640751441e+01","0.0000000000e+00","5.3640751441e+01"
"2013-02-11 11:10:00","1.0872872200e+02","0.0000000000e+00","1.0872872200e+02"
"2013-02-11 11:15:00","1.0872872200e+02","0.0000000000e+00","1.0872872200e+02"
"2013-02-11 11:20:00","8.2910444444e+01","0.0000000000e+00","8.2910444444e+01"
"2013-02-11 11:25:00","5.4392444444e+01","0.0000000000e+00","5.4392444444e+01"
"2013-02-11 11:30:00","1.2257651030e+02","0.0000000000e+00","1.2257651030e+02"
"2013-02-11 11:35:00","5.3964289701e+01","0.0000000000e+00","5.3964289701e+01"
"2013-02-11 11:40:00","1.2293081342e+02","0.0000000000e+00","1.2293081342e+02"
"2013-02-11 11:45:00","5.5050725851e+01","0.0000000000e+00","5.5050725851e+01"
"2013-02-11 11:50:00","1.2366503850e+02","0.0000000000e+00","1.2366503850e+02"
"2013-02-11 11:55:00","5.1933080639e+01","0.0000000000e+00","5.1933080639e+01"
"2013-02-11 12:00:00","1.2327244169e+02","0.0000000000e+00","1.2327244169e+02"
"2013-02-11 12:05:00","5.3967067782e+01","0.0000000000e+00","5.3967067782e+01"
"2013-02-11 12:10:00","1.2493763211e+02","0.0000000000e+00","1.2493763211e+02"
"2013-02-11 12:15:00","5.2189866667e+01","0.0000000000e+00","5.2189866667e+01"
"2013-02-11 12:20:00","1.2289600000e+02","0.0000000000e+00","1.2289600000e+02"
"2013-02-11 12:25:00","NaN","NaN","0.0000000000e+00"
"2013-02-11 12:30:00","NaN","NaN","0.0000000000e+00"
"2013-02-11 12:35:00","NaN","NaN","0.0000000000e+00"
"2013-02-11 12:40:00","4.1066666667e+01","0.0000000000e+00","4.1066666667e+01"
"2013-02-11 12:45:00","6.7625600000e+01","0.0000000000e+00","6.7625600000e+01"
"2013-02-11 12:50:00","6.7625600000e+01","0.0000000000e+00","6.7625600000e+01"
"2013-02-11 12:55:00","NaN","NaN","0.0000000000e+00"
"2013-02-11 13:00:00","NaN","NaN","0.0000000000e+00"
"2013-02-11 13:05:00","NaN","NaN","0.0000000000e+00"
"2013-02-11 13:10:00","4.1481481481e+01","0.0000000000e+00","4.1481481481e+01"
"2013-02-11 13:15:00","NaN","NaN","0.0000000000e+00"
"2013-02-11 13:20:00","NaN","NaN","0.0000000000e+00"
"2013-02-11 13:25:00","NaN","NaN","0.0000000000e+00"
"2013-02-11 13:30:00","NaN","NaN","0.0000000000e+00"
"2013-02-11 13:35:00","3.9244353923e+04","1.3196922871e+05","1.7121358264e+05"
"2013-02-11 13:40:00","3.9244353923e+04","1.3196922871e+05","1.7121358264e+05"
"2013-02-11 13:45:00","1.9867391538e+04","6.8682010238e+04","8.8549401776e+04"
"2013-02-11 13:50:00","1.9867391538e+04","6.8682010238e+04","8.8549401776e+04"
"2013-02-11 13:55:00","4.5160224430e+03","1.7070253830e+04","2.1586276273e+04"
"2013-02-11 14:00:00","4.1828921793e+03","5.6060729258e+03","9.7889651050e+03"
"2013-02-11 14:05:00","2.6965296620e+03","6.6305883216e+03","9.3271179836e+03"
"2013-02-11 14:10:00","2.4490971576e+02","1.2391736729e+02","3.6882708306e+02"
"2013-02-11 14:15:00","4.4019733333e+02","5.5652666667e+02","9.9672400000e+02"
"2013-02-11 14:20:00","1.8588271835e+02","5.9887483204e+01","2.4577020155e+02"
"2013-02-11 14:25:00","2.5018602784e+02","4.0850743616e+02","6.5869346400e+02"
"2013-02-11 14:30:00","4.7033614270e+02","6.1605268584e+03","6.6308630011e+03"
"2013-02-11 14:35:00","3.2163340914e+03","4.9816939095e+04","5.3033273186e+04"
"2013-02-11 14:40:00","NaN","NaN","0.0000000000e+00"
"2013-02-11 14:45:00","NaN","NaN","0.0000000000e+00"
"2013-02-11 14:50:00","NaN","NaN","0.0000000000e+00"
"2013-02-11 14:55:00","NaN","NaN","0.0000000000e+00"
"2013-02-11 15:00:00","NaN","NaN","0.0000000000e+00"
"2013-02-11 15:05:00","NaN","NaN","0.0000000000e+00"
"2013-02-11 15:10:00","NaN","NaN","0.0000000000e+00"
"2013-02-11 15:15:00","NaN","NaN","NaN"
"2013-02-11 15:20:00","NaN","NaN","NaN"

[gandalf]

If a customer turns off his interface, how do I get it to insert a zero instead of NaN?

Usually, you will do this by using a nice CDEF during graphing processing. But the totals are calculated "internally" and won't see this CDEF. We will have to focus that calculation, then ... not my favorite part of the code ...
R.

[GlueGuy]

I'm totally confused now. I started looking at a couple of different reports from different customers, and the B/W totals are all over the map. Sometimes they're way to high, sometimes they are way too low. There seems to be no rhyme or reason to what the B/W totals are.

Here is an example from the same graph that was showing B/W total of > 13GB in my original post, it is now showing 3.9 GB. How can the total go down? And if it's a "projection" for the month, it's way off too. The "This month" Total started going down right around the 10th of the month.