Telegraf bytes_recv seems to be cumulative?

[RedBeardCowboy]

So I'm running TICK stack and using Chronograf to chart stats, and I'm a little confused by the data. This could perhaps be me not being a SQL guru, but seems that the values the telegraf package are sending are cumulative for bytes_recv / sent under the net stats?

[RedBeardCowboy]

OK... upon a few hours and googles.... I came across this:

https://www.homelabrat.com/pfsense-dashboard/

Where in DERIVATIVE() is mentioned

Which lead me to this query which seems to be right:

SELECT DERIVATIVE("bytes_recv",1s) FROM "firewall"."autogen"."net" WHERE time > :dashboardTime: AND "interface"='igb0'

Like mentioned in my op ... I'm not a SQL guru. Now I've just got to figure how to structure both "bytes_recv" and "bytes_sent" into one graph.

For further reference:
InfluxQL Functions

[RedBeardCowboy]

OK, after further investigation the numbers it shows are incorrect... add a *8:

SELECT DERIVATIVE("bytes_recv",1s)*8 FROM "firewall"."autogen"."net" WHERE time > :dashboardTime: AND "interface"='igb0'

For Mbps that is... unless you're one of those weirdos that does MBps

[DePingus]

@RedBeardCowboy Thanks for taking the time to answer your own question. This is exactly what I was looking for today!