Binary Sensor (on/off) count multiply and per day.

[thecem]

Hi,

thanks for helping in advance!!
To intergrate the new function of trendline to get a Idea of the heatload of a building.
I searching for a solution to use a "binary_sensor" wich counts with every "on" 0,1 m3 of gas.
(reason behind this is taht the sensor status is recorded since 2 years, but not to a number.)
Now I try to count all "on" per day, to get the value of amount of qubic meter of gas.
I try to do this with a filter to show the daly consumption in a graph for gas in m³ and kWh (9,9228)

type: custom:plotly-graph
entities:
  - entity: binary_sensor.lumi_lumi_magnet_acn001_iaszone
    filters:
      - map_y: |- 
          y === "on" ? 1 : 0
      - multiply: 0.1

Q&A:

Q1: How to count the "on"? (or maybe the "change")
Q2: Do I have to translate on:off to 1 and 0 ?
Q3: How to count the "on" per day?

Thank you for your help!

[dbuezas]

oh, to count per day, you'll need #181, which I still need to implement.
As a hack, you could do the following (in the new v3.0.0 release)

type: custom:plotly-graph
entities:
  - entity: binary_sensor.lumi_lumi_magnet_acn001_iaszone
     unit_of_measurement: m³
     filters:
      - map_y: y === "on" ? 1 : 0
      - integrate: 1d # will accumulate in units per day
      - resample: 1d #will keep 1 measurement per day only
      - delta # will subtract each two consecutive values
      - multiply: 0.1
      - store_var: gas
  - entity: ""
     filters:
      - load_var: gas
      - trendline

[dbuezas]

Mmmm you could also do something like this:

- map_y: y === "on" ? 1 : 0
- integrate: 1d
- force_numeric # removes unavailable datapoints to avoid the next function to return NaN
- fn: |
     ({ xs,ys }) => {
         let valueAtEndOfLastDay = 0;
         return {
            ys: ys.map((y,i) => {
               if (i>0 && xs[i-1].getUTCDate() !== xs[i].getUTCDate()){
                  valueAtEndOfLastDay = ys[i-1];
               }
               return y - valueAtEndOfLastDay;
            }
         }
     }

I didn't test it, but I think something like that should do the job if the granularity of the previous one doesn't cut it

[dbuezas]

Q1: How to count the "on"? (or maybe the "change")

(y != ys[i-1] && y === "on") ? 1 : 0

Q2: Do I have to translate on:off to 1 and 0 ?

What you did is 👌

Q3: How to count the "on" per day?

See two options above

[thecem]

This is the basis:

First answer show following:

Second answer:

[dbuezas]

You need tu upgrade to v3.0.0

[thecem]

Yes you are right, I forgot to update. After update I tried following:

why is it not counting a complete number, but a fraction of 1 ?

Here is something missing but even no success.

May the first step should count the on per day....

thx a lot for you help!

[thecem]

I tried first to get a count value:

type: custom:plotly-graph
entities:
  - entity: binary_sensor.lumi_lumi_magnet_acn001_iaszone
    filters:
      - fn: |
          ({ ys }) => { let count=0; 
          return ys.map(y => { if (y=="on") count++;
          return count }) }
hours_to_show: 240
refresh_interval: 10
title: Gas

but no number!

[dbuezas]

Oh, sorry, try again, I fixed the example above

[thecem]

something with the ys: is wrong

[dbuezas]

Yaml was the issue, previous post corrected.

[thecem]

the counting works! Perfect thanks a lot for your help!

the daily values are a hard one:

type: custom:plotly-graph
entities:
  - entity: binary_sensor.lumi_lumi_magnet_acn001_iaszone
    filters:
      - fn: |
          ({ ys }) => {
            let count=0;
            return {
                ys: ys.map(y => {
                    if (y=="on") count++;
                    return count
                })
             };
          }
      - force_numeric
      - map_y: y * 0.1
      - fn: |
           ({ xs,ys }) => {
               let valueAtEndOfLastDay = 0;
               return {
                  ys: ys.map((y,i) => {
                     if (i>0 && xs[i-1].getUTCDate() !== xs[i].getUTCDate()){
                        valueAtEndOfLastDay = ys[i-1];
                     }
                     return y - valueAtEndOfLastDay;
                  }
               }
           }
hours_to_show: 240
refresh_interval: 10
title: Gas