Question with Filters - Integrating and Resampling Data and filterung x by datetime

[marce14-git]

Hey there,

I am sorry to bother you again, because i am not able to resolve my problem by myself.
as discussed in the HA Forum
HA-Link

I have 2 Problems:

1. i have a local precip sensor which gets roughly every 5min a value, but i would like to sum those values up and display them only every hour, like the values from openweather for better visual comparison

   filters:
      - integrate: 
           unit: h
           reset_every: 1h
      - resample: 1h
      - multiply: 12

As suggested i tried to use the integrate filter and resample but i get completly wrong values

in the screenshot below are the raw numbers if i delete the filters from above (no recent values before the displayed below)

2. Question:
   as suggested i dont want to display values which are older than NOW

so i tried using filters

    filters:
      - store_var: precipitation_p
      - fn: |-
          ({ meta, vars }) => ({
            xs: [vars.precipitation_p.xs.slice(-1)[0],...meta.forecast.map(({ datetime }) => new Date(datetime))],
            ys: [vars.precipitation_p.ys.slice(-1)[0],...meta.forecast.map(({ precipitation_probability }) => precipitation_probability)],
          })
      - filter: x > Date.now

BUT if i use this filter the whole line DISAPPEARS

Question 2 is only a minor annoyance but on paper the fix seems easy, if it would work

thanks very much in advance

[dbuezas]

Hello there!

For problem 1

Let's go through it: if the report is every 5 minutes, I assume that you get the total mm rained in the last 5 minutes only.
When you integrate, the system assumes the value is returning "rate of rain per hour", whereas the data actually has the "rate of rain per 5 minutes" (or total rain in the last 5 minutes).
Therefore, multiplying by 12 (60/5) should give you the correct results. Please try duplicating the trace, but this time removing the resample and check if the last values of each hour look correct and post some screenshots. If they do, then the resample may be picking the value on the wrong place.

For problem 2

Date.now is actually a function, so you need to call it:
filter: x > Date.now ==> filter: x > Date.now()

---

[marce14-git]

thanks for your swift answer

ad 2:
Thanks - i am a moron :D it works now, THANKS!

ad 1:

    filters:
      - integrate: 
           unit: h
           reset_every: 1h      
      - resample: 1h
      - multiply: 12

so the RED bar at 11 is correct its 4 (there is 1 value=1 behind an orange bar at 10:35)
BUT all the other small red bars before are false! there was 0,1mm rain at 4:40 and then nothing until 10:10 where i inserted some values for testing

thanks in advance

[dbuezas]

Oh I think I know what's going on. Can you plot it as lines instead of bars? this hides unavailable datapoints.
Try resample: 5m BEFORE integrating to ensure there are datapoints everywhere.

[dbuezas]

(I mean adding the 5 min resample before integrating, and leaving the 1h one after)

[marce14-git]

Oh wow, i didnt even know u could use multiple resamples

i checked, and i get datapoints every 10min +- a few seconds (i guess thats the reason its somtimes a a tiny bit off), but nevertheless you solved the problem <3

thank you so much

[marce14-git]

again thank you so much and sorry for asking again, i searched all topics on github and the HA forum but i cant get it done...

I am trying to replicate my Apexcharts graph(was slowing my HA on mobile down)

the last thing that is missing is the marker/annotation/label of the min and max temperature - is that possible? and if yes would it be possible to show the min/max of the last 24h at the line graph?

[dbuezas]

Hi Marce,
there's no pre made feature for this, but it can be achieved with an extra trace and filters. I'll give it a try and get back here when I have time.

[dbuezas]

Can you put this in a new Q&A discussion please? It will be easier for others to find it by title

[marce14-git]

of course and again thank you very much new Q&A

[dbuezas]

Thanks! I'll take a look soon :)