[solved] Counter to increments/s or increments/h

1

Hello everyone,

i want to graph the traffic over my LoRaWAN-Gateways. I have a pythonscript which fetches the data every 5 minutes from TTN. I get total packages ever. The data in the InfluxDB looks like this:

time			downlink	gw		uplink
----			--------	--		------
1593327916130004685	1768		iten_home	172972
1593328378219904378	1768		iten_home	172973
1593328405756249564	1768		iten_home	172973
1593328528427880192	1768		iten_home	172973
1593329102087026978	1768		iten_home	172974
1593329402019157379	1768		iten_home	172974
1593329702033195788	1768		iten_home	172974
1593330001872741060	1768		iten_home	172975
1593330301690632418	1768		iten_home	172975
1593330602364540804	1768		iten_home	172975
1593330902081060552	1768		iten_home	172976
1593331201524431727	1768		iten_home	172977
1593331502223416341	1768		iten_home	172977
1593331801796162611	1768		iten_home	172977
1593332102012166541	1768		iten_home	172978

Now i want to plot these not as total packages, but as packages per hour our packages per second or something like this. How can I achieve this?

Tanks a lot, Edi

2

OK, i got my problem… data was saved as String, not int. now, derivative(last()) works like a charm!