Do not consider values that are too far from the average of the previous ones

Grafana Graphite
1

Hi everyone, I would like to create home assistant charts. Occasionally (for unknown reasons) there is some reading error from a modbus sensor. I would like not to consider values that are too different from the previous ones. Eg. If a value is more than 20% different from the average of the last 5 it should not be considered. I would like to eliminate the spikes that are seen in the attached graph. There’s a way?

2021-12-07_14h53_35
2021-12-07_14h53_35998×339 23.4 KB

2

To remove spikes you can use Graphite functions for data filtering like removeAboveValue/Percentile and removeBelowValue/Percentile (Functions — Graphite 1.2.0 documentation). It won’t do exactly what you’re looking for but may help to filter out unwanted values.

Screen Shot 2021-12-13 at 11.32.34
Screen Shot 2021-12-13 at 11.32.342908×1492 301 KB

Screen Shot 2021-12-13 at 11.32.54
Screen Shot 2021-12-13 at 11.32.542940×1492 322 KB

3

Hi, thank you!
where i can find the graphite functions? consider that i’m using grafana on influxdb on Home assistant (HASSIO) installation

Best regards and thanks so much

4

Oh I thought you were using Graphite (the post is in Graphite category). If you’re using InfluxDB I think you can simply pass AND "field" < threshold to the WHERE clause to filter out spikes:

without filtering

Screen Shot 2021-12-13 at 13.57.58
Screen Shot 2021-12-13 at 13.57.582928×1548 277 KB

with filtering:

Screen Shot 2021-12-13 at 13.57.48
Screen Shot 2021-12-13 at 13.57.482954×1554 325 KB

(Only display values over a certain threshold - #4 by katy - Dashboards - InfluxData Community Forums)