Collecting RuuviTag measurements and displaying them with Grafana


#162

Acceleration:


#163

Hello,

The battery voltage really varies with the temperature, so there is nothing to compensate.

Both humidity and pressure calculation use temperature when converting from raw ADC value to physical value.

Accelerometer is not temperature compensated, as STM does not provide any kind of compensation curve.


#164

Is there a change log or something for the ruuviberry image? I got 2018-05 image without e.g. apache and trouble setting date and getting network via ethernet.

I am also not able to get the ruuvi-names.properties to work, the tags show up as e.g. ruuvi_measurements.mean {mac: E6034A5BF58D}


#165

Also, I am not able to run hcitool lescan without Input/Output error
I have to run sudo hciconfig hci0 reset first to get it to work.


#166

There’s no changelog, but you can find the description of image at https://lab.ruuvi.com/ruuvitag-fw/ .
What version of Raspberry Pi you’re running?

Grafana shows all tags by mac on default, you can configure the aliases if you want to.


#167

For the name tags to work you need to add a GROUP BY clause as tag (name) in the panel configuration on the Metrics tab, because otherwise InfluxDB will not return the names to Grafana. The example planels have only tag (mac) as the GROUP BY. After that you can set ALIAS BY to $tag_name for example.


#168

Is there a way to change the temperature measurement and display to Fahrenheit in the JSON file that you import into Grafana???

Thanx in Advance


#169

You could configure the conversion with math operation in value field


#170

I was never that good at math…How would I go about configuring it?


#171

I think this should do the trick.


#172

OK, Thanx a bunch!!!


#173

I’ve got Raspberry pi 3


#174

hey guys, could anyone please help me with a tickscript?

goal: get notificated when humidity of Ruuvi1 is lower than humidity of Ruuvi2.
my actual try after some fails:

{{{
var ruuvi1= stream
|from()
.database(‘ruuvi-measurements’)
.retentionPolicy(‘autogen’)
.measurement(‘humidity’)
.where(lambda: “name” == ‘ruuvi1’)
.groupBy(*)
|httpOut(‘ruuvi1’)

var ruuvi2= stream
|from()
.database(‘ruuvi-measurements’)
.retentionPolicy(‘autogen’)
.measurement(‘humidity’)
.where(lambda: “name” == ‘ruuvi2’)
.groupBy(*)
|httpOut(‘ruuvi2’)

ruuvi1
|join(ruuvi2)
.as(‘ruuvi1’, ‘ruuvi2’)
.tolerance(1s)
|httpOut(‘join’)
|eval(lambda: “ruuvi1” < “ruuvi2”)
.as(‘diff’)
|alert()
.message(‘test’)
.telegram()
.chatId(‘6’)

}}}


#175

how can I remove the wifi hotspot and connect to a router with the image? As it was before.

edit: got the br0 removed…

/Andre’


#176

Hello,
One more thing…How do you convert Pascals to Inches of Mercury (inHg) in Grafana???

Please lemme know.

Thanx.


#177

Hello,

You could use the math function to convert the value


#178

I don’t know what values to enter…Enlighten me, please.


#179

Hello,

we’ll check the conversion factor from the Google


And then apply the conversion in value field of the query

You can then edit the header of graph in “General” tab


#180

Thanx for responding.


#181

Hi,

I would like to store data to two separated DB’s at same time, for backup purposes. I am currently taking backups on OS-level by shutting down DB and tarring&zipping needed DB-files followed by startup of the DB.

It would be handy to store data from collector directly to two DB’s, something like this:

.# Base url to connect to, including protocol, hostname or ip address, and port
influxUrl=http://192.168.0.199:8086
Backup_influxUrl=http://192.168.0.200:8086

.# InfluxDB Database to use for measurements
influxDatabase=ruuvi
Backup_influxDatabase=ruuvi

.# InfluxDB measurement name to use for measurements
influxMeasurement=ruuvi_measurements
Backup_influxMeasurement=ruuvi_measurements

.# Username and password to use in influxdb. These can be ignored if you don’t use authentication in InfluxDB.
influxUser=ruuvi
Backup_influxUser=ruuvi
influxPassword=secret
Backup_influxPassword=secret

This requires code change of course…