I have a Binary sensor from an ESP32 module running ESPHome, the binary sensor works as it should be and the state of the sensor changes at most three times a day, however when i want to plot the state graph of the sensor using grafana and influxDB as you might see the problem it does not work as i intend it to be, the sample count for grafana and influxDB is too low to plot the graph and i have to set the timeline of the graph to show the data for more than a day to see something meaningful, although i know and understand the pure logic why the Recorder works this way, i also believe continuous recording should be a possible feature to those who wants to use it, I tried the following steps to fix this issue without any luck:
manually published the binary sensor state from ESPHome using interval automation method
created a custom sensor that continuously updated it’s state based on the binary sensor state and published it to grafana
used the fill previous feature of grafana and influxDB with no luck