Calculating delta in network traffic graph

I am having trouble with getting the delta from my network traffic. So my idea is to calculate the delta and in case I see a large dip(delta) in the graph to report that. I have tried with derivate, difference and non_negative_derivate, but no luck…

Any suggestions?

Hi,

What datasource are you using ?

Good Luck

yes non negatie derivate is good, can you show your whole query line?

Hey @wlargou , I am using jti_openconfig_telemetry in Telegraf.

@melrose This is just for graphing the network traffic…

SELECT non_negative_derivative(mean("/interfaces/interface/state/counters/in-octets"), 1s) *8 AS “Ingress Traffic” FROM /interfaces/ WHERE (“device” =~ /^Routers/ AND “/interfaces/interface/@name” =~ /^Interface/) AND timeFilter GROUP BY time(__interval), “/interfaces/interface/@name” fill(null)

So can you please let me know what I need to change to just get the delta?

looks good to me

[quote=“stefaniradevska, post:5, topic:43314”]

ic” FROM /interfaces/ WHERE (“device” =~ /^Routers/ AND “/interfaces/interface/@name” =~ /^Interface/) AND timeFilter GROUP BY time(__interval), “/interfaces/interface/@name” fill(null)

So can you please let me know what I need to change to just get th
[/quo looks goot to me

@melrose but this is not giving me the delta…

what is it giving then?