Math on the following query

Grafana
1

I have this query to get the throughput of an interface:
SELECT derivative(first(bytes_recv), 1s) as "download bytes/sec" FROM net WHERE time > now() - 1h AND interface = 'p2p1' AND host = 'mbue01speedserver' GROUP BY time(10s), interface fill(0);

How can I add a math function to it?

2

What sort of math function?

3

I would like to multiply the result by 8

4

Have you tried

SELECT derivative(first(bytes_recv), 1s)*8  as "download bytes/sec" FROM net WHERE time > now() - 1h AND interface = 'p2p1' AND host = 'mbue01speedserver' GROUP BY time(10s), interface fill(0);

Similar queries work for my using influx. Though I have not tried it with derivative.

5

Great, thank you! I thought I have to use the math function.

Can be closed!