Interface Statistic - Byte per sec, how Cacti calculate the Total In/Out

[lingchia]

Hi,

Need help on how cacti get the Total In & Total Out

I just installed the cacti 1.2.25 & created graph for interface statistics for Mikrotik.

i export the graph data to excel, i sum up the Inbound & Outbound data, its not equal to the Total In & Total Out value shown on the graph. Would like to understand how is cacti calculate the Total In & Total Out?

Below the downloaded data, they have 4 columns (col12-a, Inbound, col14-c, Outbound)
The col12-a & inbound , and the col14-c & outbound have the same value.

i addup all the Inbound value, its not equal to the total bandwidth shown on the graph. Anyone know how cacti calculate the total?

Screenshot 2023-10-12 at 4.20.51 PM.png (335.26 KiB) Viewed 1409 times

Date col12-a Inbound col14-c Outbound
12/10/2023 0:10 1286.64 1286.64 3442.72 3442.72
12/10/2023 0:15 1270.36 1270.36 3382.40 3382.40
12/10/2023 0:20 1289.50 1289.50 3357.18 3357.18
12/10/2023 0:25 1258.10 1258.10 3390.22 3390.22
12/10/2023 0:30 1207.21 1207.21 3359.69 3359.69
12/10/2023 0:35 1222.99 1222.99 3360.49 3360.49


Thank you

[cigamit]

You would have to post the whole data set for that time period of the graph for us to see anything. You posted 6 rows (25 minutes worth), the graphs shows 193 (16 hours worth)

[lingchia]

Hi cigamit,

Thank you for your reply.

After some reading, I have got the idea how to get the total bandwidth.

[Osiris]

In simple terms it's the average over the period * second over the period. In modern cacti, you would just use a vdef, but the old graph templates pull the raw data and then do the math.