Second, derivative function rate normalisation parameter is incorrect. According to influxdb docs it should be 1s by default:
DERIVATIVE() can have two arguments. The first is required and is a field name. The second is optional and is a rate normalization parameter. If the second parameter is not provided defaults to 1s.
In reality with v0.9.4.2 i see derivative(mean("value")) and derivative(mean("value"), 1s) show different results and the later one is actually correct.
In reality with v0.9.4.2 i see derivative(mean("value")) and derivative(mean("value"), 1s) show different results and the later one is actually correct.