Comments

• 

  7 days ago by fcrozat | Reply

  After a lot of digging, I found the solution: you need to use SQL integration to query Home assistant long term statistics and create related sensor.

  For instance: > SELECT state FROM statistics JOIN statisticsmeta ON statistics.metadataid = statisticsmeta.id WHERE (statisticsmeta.statisticid = 'sensor.shellyemenergy' AND startts <= strftime('%s', 'now','start of day')) ORDER by start_ts DESC LIMIT 1

  to access the value of the sensor at midnight the same day

×
Edit Comment 8887
# A First Level Header
## A Second Level Header

Use one asterisk to *emphasize*

Use two asterisks for **strong emphasis**

- Use hyphens
- for unordereed
- lists

This is an [link to example.com](http://example.com/)

This is an image ![an openSUSE geeko icon](https://en.opensuse.org/images/d/d0/Icon-distribution.png)

This is a user link @hans

This is a project link hw#some-cool-title
More Complex Markdown Help
Formatting Help
• Edit
• Preview
After a lot of digging, I found the solution: you need to use SQL integration to query Home assistant long term statistics and create related sensor. For instance: > SELECT state FROM statistics JOIN statistics_meta ON statistics.metadata_id = statistics_meta.id WHERE (statistics_meta.statistic_id = 'sensor.shelly_em_energy' AND start_ts <= strftime('%s', 'now','start of day')) ORDER by start_ts DESC LIMIT 1 to access the value of the sensor at midnight the same day
 
×
Reply to fcrozat
After a lot of digging, I found the solution: you need to use SQL integration to query Home assistant long term statistics and create related sensor.
For instance: > SELECT state FROM statistics JOIN statisticsmeta ON statistics.metadataid = statisticsmeta.id WHERE (statisticsmeta.statisticid = 'sensor.shellyemenergy' AND startts <= strftime('%s', 'now','start of day')) ORDER by start_ts DESC LIMIT 1
to access the value of the sensor at midnight the same day
---
# A First Level Header
## A Second Level Header

Use one asterisk to *emphasize*

Use two asterisks for **strong emphasis**

- Use hyphens
- for unordereed
- lists

This is an [link to example.com](http://example.com/)

This is an image ![an openSUSE geeko icon](https://en.opensuse.org/images/d/d0/Icon-distribution.png)

This is a user link @hans

This is a project link hw#some-cool-title
More Complex Markdown Help
Formatting Help
• Edit
• Preview