I'm trying to make a visualization for my current sensors (link: Calculate kWh)
Doing some more deep analisys on the problem, I'm facing an issue that I cannot resolve.
The average values showing in the visual builder are completely different from the real ones (doing manual math calculation). This is REALLY frustrating.
I'm doing 4 hours average/count (absolute range).
The average values should be (5m interval):
- en_sensor1: ~ 331,98
- en_sensor2: ~ 222,60
- en_sensor3: ~ 38,10
Manually counting the raw data shows me 49 measures.
I'm getting (5m interval) - Which aparrently are the last values from the series:
- en_sensor1: ~ 556,63
- en_sensor2: ~ 166,78
- en_sensor3: ~ 37,52
Converting the metric to count shows me 42 measures.
Time Series Visual Builder:
Metric Visual Builder showing average:
Metric Visual Builder showing count:
Using the simple "Metric" visualization, I got values closer to the real manual calculated ones as shown below:
Ps.: Using 08:05:00 as last number in time range just to make kibana get the last value from 08:00:00. Changing this to 08:00 doesn't solve the problem.
Can anybody help?
Download the Raw Data