[SOLVED] Grafana not storing / historizing some particular items

Add-ons Persistence Services
, ,
1

Hi,

i have been trying to store the ultrasonic sensor values to Grafana with Influxdb, But its not storing some particular tag values, Rest of the values are storing fine…why is this happening ? See in this below pic Ground Tank Level item which is manipulated value of tanklevel item is only shown. No value change of tanklevel is seen.

image
image.png1893×462 49.7 KB

image
image.jpg1910×852 163 KB

Persistence file

Strategies {
    everyMinute : "0 * * * * ?"
    everyHour   : "0 0 * * * ?"
    everyDay    : "0 0 0 * * ?"
		
		default = everyChange
}

Items {
		Databasesizetm,memUsed,diskspaceused,openhabCpuPercent,HT_Temperature,HT_Humidity,Gateway_AmbientLight,G_Gateway_AmbientLight : strategy = everyChange

		InfluxDB_Size,GroundTanklevel,tanklevel : strategy = everyChange
}

Item File

Number GroundTanklevel "Ground Tank Water Level [%.2f %%]"


Number tanklevel "Distance [%s CM]" {mqtt="<[broker:tele/ultrasonic/SENSOR:state:JSONPATH($.SR04.Distance)]"}

Rule File

rule "Final level"
when
	Item tanklevel received update
then
	if(tanklevel.state instanceof DecimalType)
	{
	GroundTanklevel.postUpdate((0.645 * (195 - (tanklevel.state as DecimalType))) + 0.025) // y == mx+c equation
	}	
end

Throw some light if i am missing something…

2

Do you actually get the right value outside of Grafana?

More particular, is the rule actually triggered? (the item definitions might be helpful here)

3

IMG_20180907_101709
IMG_20180907_101709.jpg1080×1391 216 KB

Soon i will provide you item definition for time being please see graph of rrd4j is able to see the changes…

4

Maybe the question is a little stupid, but on the time interval, the grafana screenshot seems to show the same (constant) value as your rrd4j screenshot… are you sure you don’t just look at the wrong interval?
Because you obviously have some (really small) changes in value.

5

Change this in grafana:

image

6

image
image.jpg1916×905 175 KB

image
image.png1895×463 41.7 KB

image
image.jpg1917×793 152 KB

I tried distinct() but no changes were recorded for tanklevel item (Raw input from sensor)

I have updated my main post with item file & influxDB Persist configuration details please check

7

Can you show your events and openhab log when the value of tankLevel changes, please?

8

tank_openhablog.pdf (36.5 KB)
tank_event.pdf (107.4 KB)

Please Find attached files

9

Your items are updating and the rule is running
So try changing
image
default to autogen
for both items

10

Or maybe try creating a new chart with both items both with autogen and distinct

11

image
image.png1904×903 96.8 KB

Please check i did try to create new chart but only groundtanklevel item is visible and raw input tanklevel item is not still…updating…

Any idea…

12

If you create a chart with ONLY tanklevel what do you get?

13

Empty :frowning:

image
image.png1890×465 24.2 KB

14

Your item is not being persisted.
Did you restart OH since adding it to the persist file?

15

After Restarting… i am able to see some positive… atleasdt sensor raw value text is visible with reading. Fingers…crossed…until value actual fluctuates…

image
image.png1920×711 39.3 KB

udpated after 1 hour (Persisted, every minute and every change)

image
image.png1582×424 32.9 KB

16

Problem solved!