# App setup: missing values and app URL

**URL:** <https://community.openenergymonitor.org/t/app-setup-missing-values-and-app-url/24759>\
**Category:** Applications\
**Tags:** heatpumpmonitor\
**Created:** [12 November 2023 21:53 UTC](https://community.openenergymonitor.org/t/app-setup-missing-values-and-app-url/24759 "2023-11-12T21:53:43Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![qris](https://community.openenergymonitor.org/user_avatar/community.openenergymonitor.org/qris/32/8820_2.png) [@qris](https://community.openenergymonitor.org/u/qris)\
**Post date:** [12 November 2023 21:53 UTC](https://community.openenergymonitor.org/t/app-setup-missing-values-and-app-url/24759/1 "2023-11-12T21:53:44Z")

</div>

I’ve been logging my heat pump data on a local emonPi and in a SQL database for 3 years. I’ve finally got around to publishing it all on [emoncms.org](http://emoncms.org) and setting up the MyHeatpump app to publish on [heatpumpmonitor.org](http://heatpumpmonitor.org) (awaiting review).

When I look at the data in the MyHeatpump app, I see days with apparently no heat/electricity data, e.g. November 9th and 10th:

 ![MyHeatpump app with missing days](https://community.openenergymonitor.org/uploads/default/original/3X/6/5/652a3fb7f94dea120e23204049268a862f5c1e91.png)

However as far as I can see, all the data is there in the underlying feeds:

 ![Feeds graph with no missing days](https://community.openenergymonitor.org/uploads/default/original/3X/a/2/a2d5fe3595dfb966d95d90b7625e2b62b2873ea9.png)

Any idea what the problem is?

Also, I managed to find a “public” URL for my app at [Emoncms - app view dashboard](https://emoncms.org/qris) (by guessing), which I linked to on my published system profile, but otherwise I would have had to expose my read-only API key, as I think many others have. Perhaps it’s worth making it easier to find this public URL and/or blocking URLs that include the API key?

---

<div class="post-metadata">

**Author:** ![Timbones](https://community.openenergymonitor.org/user_avatar/community.openenergymonitor.org/timbones/32/20308_2.png) [@Timbones](https://community.openenergymonitor.org/u/Timbones)\
**Post date:** [12 November 2023 22:41 UTC](https://community.openenergymonitor.org/t/app-setup-missing-values-and-app-url/24759/2 "2023-11-12T22:41:37Z")

</div>

Hi, thank you for submitting your system to [heatpumpmonitor.org](http://heatpumpmonitor.org).

It seems that your kwh feeds contain some nulls, which can happen if the interval of the feed is higher than it is being populated with. For example, if they are PHPFINA feeds created with 10s interval, but values are being logged every 1 minute so the gaps are full of nulls. The feed is being sampled at 00:00 every day, so when that happens to fall between readings, you get a null.

If you’re able to recreate those feeds with the right interval, then the bar graph will look right. Alternate option is to use `Log to feed (Join)` which fills in the gaps between values, but this isn’t an option if you’re using `Power to kwh`.

I also notice that on the power chart (when you click on a bar), you have the heat and electric feeds swapped, hence the very low COP.

---

<div class="post-metadata">

**Author:** ![Timbones](https://community.openenergymonitor.org/user_avatar/community.openenergymonitor.org/timbones/32/20308_2.png) [@Timbones](https://community.openenergymonitor.org/u/Timbones)\
**Post date:** [3 December 2023 17:56 UTC](https://community.openenergymonitor.org/t/app-setup-missing-values-and-app-url/24759/3 "2023-12-03T17:56:01Z")

</div>

Was my answer helpful? Have you managed to sort out your feeds? Do you need any more help?