Help me with query functions?

InfluxDB 2 Dashboards
1

Hello,

Please help me to rewrite Influxdb query to get bits/sec, which functions to use?

I have this metrics flow:
[Network router] --> [collectd (snmp query every 5 min)] --> [InfluxDB]

InfluxDB query:
SELECT "value" FROM "snmp_rx" WHERE ("host" = '192.168.0.1' AND "type" = 'if_octets' AND "type_instance" = 'ether1');

Data sample:

1519737493206360257 2400722554
1519737553206778831 2950898359
1519737613208459690 3449887538
1519737673211327231 3922887881
1519737733206444985 4272607821
1519737793210287145 341307076
1519737853210112376 757238817
1519737913211383315 1288984885
1519737973225079146 1796991745
1519738033206794903 2300163900
1519738093209727495 2722622151
1519738153207606590 3160296338
1519738213208986343 3523024527
1519738273205160999 3937718955