Turn past state changes into data for Grafana

Hi homies,

as probably everyone knows there’s a history of state changes for every entity, I would like to display that state change history of a particular entity as dots in a Grafana plot with X-axis being basically a day slice and Y-axis the time of that day when the event occurred.

Do you have suggestions how to approach this problem?

I do have Node-RED and AppDaemon, in case these might be helpful or necessary.

Thank you!

PS: thanks for moving the topic to the right category!