Hi,
Is it possible to create a card in the dashboard that would show the opening time from the door and window sensor (binary sensor).
Exactly, it is about displaying in the form of a table the last fifteen openings lasting longer than a certain time, for example lasting longer than 5 minutes. The last opening would have to be read from the current time.
in the example below, the date and time format is an example
Main challenge is retrieving this information… unless you already have a solution for that, you either require to store this in different input helpers or with more tweaking in the attributes of some entity.
Getting the data probably means sql query on either states or statistics table, each SQL ientity will only give you one value (the first of the query) regardless what you put in the query
When you have the data, you can then use markdown card or flex-table card or entities to display it
with influxDB query
SELECT * FROM "homeassistant"."autogen"."state" WHERE ("entity_id" = 'drzwi_ganek_kuchnia_contact')
I was able to extract the following data:
but I don’t know how to transfer it to the dashboard
As mentioned, you’d need a SQL integration and you will need 1 for each value
It might be easier to create a influx dash or grafana and integrate that into HA
I’m a new Home Assistant user, I’ve been using it since the beginning of the year. Can you recommend a guide on how to connect influx or grafane with a dashboard
Have a look here, it does not come easy but likely a lot faster than creating different sql sensors
