DSstats traffic seems to be off

[fuzzbawl]

I'm not sure if it's something I'm missing or overlooking, or perhaps an actual bug. When viewing a graph for a specific interface on a device I can see that the numbers for "Last:", which I double checked and are showing Last with CDEF of "Convert bytes to bits" applied, do not quite line up with the data in data_source_stats_hourly_last. Here is the query I'm using:

SELECT host.description, host.hostname, dss.rrd_name, dss.calculated*8 as bits, (dss.calculated*8)/1024 as kbps, dss.value, dtd.name_cache from data_source_stats_hourly_last dss JOIN (data_local dl, host host, data_template_data dtd) ON (dss.local_data_id=dtd.local_data_id AND dl.id=dtd.local_data_id AND dl.host_id=host.id) WHERE name_cache like '%ath0%';

This shows the value of "47.8359" for traffic_out in kbps column, but the graph in Cacti shows the Last as 52.03k

Am I missing something?

[browniebraun]

The results will differ, because
RRDtool automatically interpolates measured values with respect to their delay
while DSTATS does not support this.

Regards
-Andi