Sorry if this is the wrong place ,but I know there has to be people that have this down to a fine science .
What is the best way in your opinion to compare two or more variables looking for patterns? Right now the best I’ve found is just making a history card and starring at them until I notice something.
Are there any good guides and how to compare two sets of data in Grafana for home assistant data? Like two separate types of input say energy usage and humidity and plot it on one graph to see if they correlate?
Let’s say as an example I thought a roommate was leaving his window open while the AC was running. How could I say compare the average run time of the AC while he was home compared to the average runtime of when he wasn’t home and maybe account for other variables like humidity, solar angle and outside temperature?
Just want to hear the innovative solutions people have come up with with their own problems.