I’ve setup influxDB for my time series data to log total consumption counters. This was a succes by far. Now that I have the data I want to visualize it as follow:
RAW DATA as follow:
select value from consumption
As you can see, the data looks like daily received, but definitely not perfect on the same time, making the difference() function nog suitable for this.
Also, notice the data loss on 2018-05-04
Also, notice the excess of data on 2018-05-10
These 3 facts that can and will happen with the data make the functions difference() and integral() etc… not suitable for error prove visualization.
also, it is possible that meter1 makes his data available every day, meter2 every hour, meter3 every 15 minutes, and meter4 not time based but event based of threshold based.
I want to visualize this data as consumption within variable time blocks, let say, all meter consumption on 15 minute base.
Does anyone knows the solution or a hint for that?
I allready searched google, grafana and influx forums. Wat terms I allready found are pre-bucketed data, and that the histogram() function for influxdb is not available yet.
I reconstructed the problem on my homeserver at:
I created demo data for meter1 and meter2. This is the printscreen from meter2, with 2 times missing data and once excess data. With the difference() function I get 2 spikes and one fall.