Reportit handling of NAN

[GlueGuy]

I think this might be termed a philosophical issue, but it appears that Reportit treats NAN data as non-existent.

This may be technically correct, but it throws off calculations to find the aggregate data passed for a period of time (day, week, etc.).

As an example, we have a customer that turns off their equipment when they're not using it. As a result, SNMP queries to their interface yield NAN data when it's off, which is most of the time.

When I run the report, all the NANs get thrown out, and the only data points are when the interface is on, and moving data.

I plug the averages into a spreadsheet, and calculate the daily aggregate data by that customer, but that is way off, as all the zero data points are missing.

Perhaps there could be an option for how NANs are handled: throw away, or as zero?

[GlueGuy]

Well, if you leave me to it long enough, I sometimes figure it out.

As I (eventually) got to poking through some of the Reportit threads, I found that I could use the formula:

(f_num*step/1000000000*f_avg)

which gives me GB, and setting the window to monthly, I get what I "think" I wanted in the first place.

However, there is an anomaly. I have a couple of devices acting as a router to other customers. I would expect the sum of the subs to be less than the total going through the router, but in a couple of cases the sum of the subs exceeds the total through the router (some of the others don't do this).

Example:

Code: Select all

Router        16.83 GB/month
Sub1          16.07 GB/month
Sub2           7.62 GB/month
Sub3           5.18 GB/month
----------------------------
Sub total     28.87 GB/month
============================
Net          -12.04 GB/month

I would think that it should be impossible for the total of the subs to exceed the throughput of the router.

Is there something I may be misunderstanding (hah! now there's an understatement!)?