# \[APP\]\[Pro\] InfluxDb

**URL:** <https://community.homey.app/t/app-pro-influxdb/32405>\
**Category:** Apps\
**Tags:** app\
**Created:** [July 15, 2020, 5:21am UTC](https://community.homey.app/t/app-pro-influxdb/32405 "2020-07-15T05:21:40Z")\
**Posts on this page:** 20\
**Page:** 8

<div class="post-metadata">

**Author:** ![Friedhofsblond](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/friedhofsblond/32/93838_2.png) [@Friedhofsblond](https://community.homey.app/u/Friedhofsblond)\
**Post date:** [January 20, 2024, 7:52pm UTC](https://community.homey.app/t/app-pro-influxdb/32405/144 "2024-01-20T19:52:29Z")

</div>

Oh sorry.  
I used an old token - stupid me 🙄

---

<div class="post-metadata">

**Author:** ![Sharkys](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/sharkys/32/54029_2.png) [@Sharkys](https://community.homey.app/u/Sharkys)\
**Post date:** [February 13, 2024, 12:35pm UTC](https://community.homey.app/t/app-pro-influxdb/32405/145 "2024-02-13T12:35:41Z")

</div>

FYI, do you also observe growing memory footprint of InfluxDB over time ?

 ![obrazek](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/7/5/75da9b4a5be71ff26d46442dd156bc95bc6fb422.png)

---

<div class="post-metadata">

**Author:** ![Marius\_Stensrod](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/marius_stensrod/32/56540_2.png) [@Marius\_Stensrod](https://community.homey.app/u/Marius_Stensrod)\
**Post date:** [February 13, 2024, 12:40pm UTC](https://community.homey.app/t/app-pro-influxdb/32405/146 "2024-02-13T12:40:53Z")

</div>

Same here. The Drop is a restart of the app.

 ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/9/d/9d0530dfe6a281ab24df35c1076cd86816d5d86d.png)

---

<div class="post-metadata">

**Author:** ![fmb](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/fmb/32/27097_2.png) [@fmb](https://community.homey.app/u/fmb)\
**Post date:** [March 7, 2024, 5:33pm UTC](https://community.homey.app/t/app-pro-influxdb/32405/147 "2024-03-07T17:33:44Z")

</div>

Hi!  
Using this app for a long time now, over 2 years? And works great, never gives an issue.  
I use Grafana to create some Dashboards.

There is one thing which I just cannot find a work around for; Grafana and/or InfluxDB don’t allow to show a value if the last data point in the database is outside the Grafana timerange (so outside the Query timerange). This is no issue for frequent changing values, but might be an issue for values changing just a few times per month (or even year). This is not related to the Homey InfluxDb app, but a result from how Grafana and/or InfluxDB handle the queries.

The Homey InfluxDb app writes only changed variables/values (which is a smart thing to do) and I just noticed a flowcard “Write measurement … as number…”.

So I thought: let’s try to trigger sending a new value to InfluxDB even without an actual change in it by writing the current value as new value. But I either don’t understand how the flowcard “Write measurement … as number…” works, or there is something wrong. It does not change the value in InfluxDB which a varify by looking at the last value if it in Grafana.

Any idea’s which can help me further?

---

<div class="post-metadata">

**Author:** ![Joka](https://avatars.discourse-cdn.com/v4/letter/j/7feea3/32.png) [@Joka](https://community.homey.app/u/Joka)\
**Post date:** [March 7, 2024, 7:21pm UTC](https://community.homey.app/t/app-pro-influxdb/32405/148 "2024-03-07T19:21:57Z")

</div>

I noticed the same problem you have to force a value change by adding a inkremental small value to the original value. So the value will not change much but a little bit. This triggert the data transfer again.

In the following example you can see the workaround in action. My power measure device sends the same result as the day before. The problem would be that the the app would not transfer the value to influxdb. I add 0.01 kWh and the app will recognise the change of the value and transfer it to influxdb.

 ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/1/6/163ca787c04f38747a3673d7974ae5db1d87ed9b.png)

---

<div class="post-metadata">

**Author:** ![fmb](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/fmb/32/27097_2.png) [@fmb](https://community.homey.app/u/fmb)\
**Post date:** [March 7, 2024, 7:41pm UTC](https://community.homey.app/t/app-pro-influxdb/32405/149 "2024-03-07T19:41:48Z")

</div>

Thnx for the quick reaction. That will indeed work as well, but I’d prefer not to need to change the data (even if its just a small bit). I’ll first wait and see if anyone has an idee to get the flowcard from the Homey InfluxDb work for me 😉

---

<div class="post-metadata">

**Author:** ![Pixi](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/pixi/32/109087_2.png) [@Pixi](https://community.homey.app/u/Pixi)\
**Post date:** [March 8, 2024, 10:20am UTC](https://community.homey.app/t/app-pro-influxdb/32405/150 "2024-03-08T10:20:14Z")

</div>

in grafana, change in de graph created the start date/time into -10d, for instance

---

<div class="post-metadata">

**Author:** ![fmb](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/fmb/32/27097_2.png) [@fmb](https://community.homey.app/u/fmb)\
**Post date:** [March 8, 2024, 8:21pm UTC](https://community.homey.app/t/app-pro-influxdb/32405/151 "2024-03-08T20:21:47Z")

</div>

Thanks for your response. I don’t understand yet what you mean; do you mean the time interval of the graph? Or is there another place where I should be able to fill in for example -10d (of a month or so)?

---

<div class="post-metadata">

**Author:** ![Pixi](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/pixi/32/109087_2.png) [@Pixi](https://community.homey.app/u/Pixi)\
**Post date:** [March 9, 2024, 7:47am UTC](https://community.homey.app/t/app-pro-influxdb/32405/152 "2024-03-09T07:47:15Z")

</div>

![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/4/d/4dc9770a4301c70ce9a76027c3333c070351ba0b.png)

so it would like this

from(bucket: “homey”)  
|\> range(start: -3d, stop: v.timeRangeStop)  
|\> filter(fn: (r) =\> r[“\_measurement”] == “homey\_CO\_Sensor”)  
|\> filter(fn: (r) =\> r[“\_field”] == “measure\_temperature”)  
|\> aggregateWindow(every: v.windowPeriod, fn: last, createEmpty: true)  
|\> fill(usePrevious: true)  
|\> yield(name: “last”)

---

<div class="post-metadata">

**Author:** ![fmb](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/fmb/32/27097_2.png) [@fmb](https://community.homey.app/u/fmb)\
**Post date:** [March 9, 2024, 9:29am UTC](https://community.homey.app/t/app-pro-influxdb/32405/153 "2024-03-09T09:29:48Z")

</div>

Thanks for the additional explanation!  
Will try it and share my results. No time for that this weekend, so will be next week.

---

<div class="post-metadata">

**Author:** ![parody](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/parody/32/67985_2.png) [@parody](https://community.homey.app/u/parody)\
**Post date:** [March 21, 2024, 8:46pm UTC](https://community.homey.app/t/app-pro-influxdb/32405/154 "2024-03-21T20:46:07Z")

</div>

I’m also having an issue with this. I’m using an existing influx2 DB (works fine for other purposes). I get the “connected” message and a count of metrics. But nothing in influx. How can I debug it? I’ve also tried a new api token.

 ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/b/1/b165cbbda0fb50bcb571e10196b3026a6e1b541c.png)

---

<div class="post-metadata">

**Author:** ![fmb](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/fmb/32/27097_2.png) [@fmb](https://community.homey.app/u/fmb)\
**Post date:** [March 23, 2024, 9:39am UTC](https://community.homey.app/t/app-pro-influxdb/32405/155 "2024-03-23T09:39:02Z")

</div>

I got it working in Grafana by increasing the relative time in the query options. Works for those graphs where the last value is used.

I assume it will not work for graphs where the average of for example the last day is shown and value did not change in that last day.

So I would still be interested in ideas on how to get that flowcard “Write measurement … as number…” to work 😉  
My expected behaviour of that flowcard is that any value will be written to the InfluxDB itself, also if the value is the same as the last written value.

---

<div class="post-metadata">

**Author:** ![fmb](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/fmb/32/27097_2.png) [@fmb](https://community.homey.app/u/fmb)\
**Post date:** [March 23, 2024, 9:39am UTC](https://community.homey.app/t/app-pro-influxdb/32405/156 "2024-03-23T09:39:37Z")

</div>

Thanks, brought me to increasing the relative time of a specific graph/query. Works in my case.

---

<div class="post-metadata">

**Author:** ![rjbaat](https://avatars.discourse-cdn.com/v4/letter/r/46a35a/32.png) [@rjbaat](https://community.homey.app/u/rjbaat)\
**Post date:** [March 23, 2024, 2:42pm UTC](https://community.homey.app/t/app-pro-influxdb/32405/157 "2024-03-23T14:42:35Z")

</div>

I have exactly the same. It shows connected, but not getting any data in the bucket.  
Dit you already figured how to solve this?

I tried adding a flow I have seen somewhere in this topic. But that doesn’t do much either.

---

<div class="post-metadata">

**Author:** ![Vasile\_Dumitrescu](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/vasile_dumitrescu/32/70676_2.png) [@Vasile\_Dumitrescu](https://community.homey.app/u/Vasile_Dumitrescu)\
**Post date:** [April 17, 2024, 2:27pm UTC](https://community.homey.app/t/app-pro-influxdb/32405/158 "2024-04-17T14:27:27Z")

</div>

Hello, would it be possible to expose the cache duration in settings? I would like to be able to set it as I might want to migrate influxdb to another machine without losing data, and having a longer cache duration would be very helpful with this.

Thanks

---

<div class="post-metadata">

**Author:** ![TheSource](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/thesource/32/53900_2.png) [@TheSource](https://community.homey.app/u/TheSource)\
**Post date:** [May 28, 2024, 12:41pm UTC](https://community.homey.app/t/app-pro-influxdb/32405/159 "2024-05-28T12:41:58Z")

</div>

I’m logging all my data already for some time to influxdb and visualize it via grafana. However I renamed a device in homey which also means the historical data is now missing in grafana. Can I and how to rename the old labels in InfluxDB similar to the new ones? Merge them into 1 entity under the name name?

---

<div class="post-metadata">

**Author:** ![parody](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/parody/32/67985_2.png) [@parody](https://community.homey.app/u/parody)\
**Post date:** [June 13, 2024, 11:19pm UTC](https://community.homey.app/t/app-pro-influxdb/32405/160 "2024-06-13T23:19:50Z")

</div>

Sorry I missed this. I never got it working. Not sure why. Instead I wrote my own flow that can be called to write things if / when I want. It works OK for me because I only wanted some things exported.

 ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/2/3/2351dc0afa2c0eb244037f39331d4be65da8b374.png)

---

<div class="post-metadata">

**Author:** ![luguber](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/luguber/32/16795_2.png) [@luguber](https://community.homey.app/u/luguber)\
**Post date:** [June 24, 2024, 7:29am UTC](https://community.homey.app/t/app-pro-influxdb/32405/161 "2024-06-24T07:29:16Z")

</div>

A couple of weeks ago I installed this app, and some days later the latest test version v1.2.2.  
My problem is that I don’t get any data reported for any Aqara sensors. The sensors appear in the influx database, but no data is being stored for any capability on them. (insight data is OK)  
I see some people in this Thread has had that problem as well, did you get it fixed somehow?

---

<div class="post-metadata">

**Author:** ![fmb](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/fmb/32/27097_2.png) [@fmb](https://community.homey.app/u/fmb)\
**Post date:** [October 13, 2024, 8:29am UTC](https://community.homey.app/t/app-pro-influxdb/32405/162 "2024-10-13T08:29:43Z")

</div>

I am trying to find out out if I can increase the amount of data points stored in the Influx database by InfluxDB for a specific device.

I have a Shelly Pro 3EM, which measures solar production. See below for a graph from Grafana for a time period of 5 minutes. It shows that there is new data every ± 10s but I would like to have more data in between.

If I look in the webinterface of the Shelly 3EM I see frequent changes in the measured values. Data can change roughly each second, so real time.  
If I look at the same Shelly Pro 3EM device in Homey, I see the same. So very frequent changes in values.

I use Grafana to visualise InfluxDB data and it can also show the source in table format. There I see something different. Roughly each 10 second there is an update of the measurements.

Looking around in settings of Shelly3EM of InfluxDB app I cannot find any thresholds which for example only update a measurement with a certain change value. So I don’t know if and how I can make sure each change in measurement is stored in the database.

Any suggestions how I can find out if this is caused by Homey of InfluxDB or Grafana?  
Or even better: any suggestions to fix this?

 ![](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/d/8/d8e43e92d2a8addc3159e1fd1f09a1c8cc7c5213.jpeg)

---

<div class="post-metadata">

**Author:** ![Marius\_Stensrod](https://sea1.discourse-cdn.com/flex025/user_avatar/community.homey.app/marius_stensrod/32/56540_2.png) [@Marius\_Stensrod](https://community.homey.app/u/Marius_Stensrod)\
**Post date:** [October 13, 2024, 10:12am UTC](https://community.homey.app/t/app-pro-influxdb/32405/163 "2024-10-13T10:12:47Z")

</div>

> [@fmb](#):
>
> I am trying to find out out if I can increase the amount of data points stored in the Influx database by InfluxDB for a specific device.

Firs of all, check what you have in your database for the measurement. If you got V1.x, you can do something like this in shell:

 ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/d/0/d038452db03f69107b51d089991541777c1f36e2.jpeg)

In general for Grafana: Querie Time “$\_Interval”, will give you all the measurement points of that measurement.

If you want more measure points then you have in your Influx database, you have to make more measuring points with parameteres of shelly (if possible) or append a new measuring with flow like this:

 ![image](https://us1.discourse-cdn.com/flex025/uploads/athom/original/3X/2/3/234aafcd94f09a3c36d9ee81318181db4b1bebe0.png)  
(Every 10 seconds - inluxdb online - write measurement card)

[Previous page](https://community.homey.app/t/app-pro-influxdb/32405.md?page=7)

[Next page](https://community.homey.app/t/app-pro-influxdb/32405.md?page=9)
