Wrong 24h staircase graph (solved)

i´m trying to show one data source with two different time ranges. Rain/h and Rain/d, both in staircase format.
Rain/h works fine but Rain/d shows rain on days without rain. Both use the same datasource.
Any Idea whats going wrong?


Probably related to how influxdb derivatives work, now sure how to fix it

some result with difference () transformation instead of derivative() …

got it :slightly_smiling_face:
i have to use max instead of mean…:
SELECT difference(max(“value”))