Daily sumary of selected sensor?

1

I have my own binary returns 1 or 0 based on some conditions.

Now Id like to get daily summary of all 1’s and see trend graph (breakdown by days).

Can someone guide me how to archive this other way that writing SQL queries ?

PS> I cannot use energy meters as those are in use

2

This sounds like something Grafana might be able to solve.

3

Yeah I was thinking about that - but this sound as such common use case so I wanted believe HA has something build in out-of-the-box

BTW Im checking now this: