Flow and Insights

Flows
21

In fact, I will try with that. Thank you

22

Nevertheless, here are the flows.

Required
– a Countdown or Timer app like Chronograph or CountDown
– 2 numeric variables (e.g. ConOld, ConCalc)

When…
– Every 24 hours
Then…
– Set Energie to variable ConOld

When…
– Time is 23:59
Then…
– Start Timer/Countdown with 59 s

When…
– Timer/Countdown is finished
Then…
– Calculate ConCalc as {{round(Energie - ConOld,2)}}

When…
– Time is 10:00
Then…
– Push Notification “Yesterday’s consumption was ConCalc kW/h”

Info
– The result represents the previous day’s consumption of 23 hours, 59 minutes and 59 seconds. So 1 second is missing… :wink:
– The result is given in kW/h with 2 decimals. If the result should be given in W, the formula must be as follows: {{((Energie - ConOld)*1000)}}

I hope I haven’t made a mistake, because I haven’t tried it myself… :wink:

23

Or just use Power by the Hour, and send yourself the total kWh a few seconds after midnight.Or open the PBTH device in the Homey app to see the totals of today and yesterday and last month.
Or open Insights and see the totals.

That is actually why I created PBTH, so that you do not need to create complex flows or create graphs/reports from exported data.

24

That’s what I was trying to do but in the “when” it just tells me that I can select when a value “greater” “less than” changes there is no “read” command.

How can I do that?

25

Has already been proposed 2x :wink:

26

https://homey.app/f/UunlO_

You can select any value as tag from the PBTH device:

Screenshot_20220322-165102_Homey
Screenshot_20220322-165102_Homey1080×2400 241 KB

27

So there must be some truth in it. But some people need multiple reminders before a message sinks in :wink:

1 Like
28

Nice work, I will try and I hope to succeed.
Thank you

1 Like
29

I succeeded thank you, I’m a beginner. Excuse

Thank you so much for your help

1 Like
30

No worries for asking help on the forum. That is what it is for, as long as you are willing to put in effort yourself. And you did, with success as result :partying_face:

1 Like
31

Is it possible in any way to recall via link or http command the “Insights” graph of a certain sensor and a certain time slot (example 24h)?

Example:

  1. Click link

  2. Opens the graph of the
    My humidity sensor of the last 24h (without having to select the brand and then the sensor function and then the manual period is a bit cumbersome)

image
image1284×2358 62.2 KB

I was also thinking about the “Apple shortcut” app

32

I succeeded to create an Advanced Flow where I receive MQTT messages, and extract numerical data from the message content.

I can also export time-series of these numerical data by using Archive Insights.

My ultimate goal in this project is to analyze the incoming messages by topic and to determine the reception rate per topic. So I want to record the topics of the incoming MQTT messages and store them in a text variable. So far so good.

Now I was hoping that when I export Insights with Archive Insights, I would get a file with timestamps and as values the recorded topic strings. However, when I do this, only numerical values are exported (e.g. the total message count).

How can I export text variables using Archive Insights, or in any other way?

33

I found a way to achieve my goal by using the Google Sheets app. In this way I can append the message topics, including a timestamp to a worksheet in “live” mode.

But I am open for suggestions to do this in some other way.

The nice thing about Archive Insights is that I collect the data directly on my NAS.