How to Visualize Motion Detection Heatmaps Over Time with Home Assistant and InfluxDB

Forget the Logbook, See the Story of Your Home

Let's be real. Scrolling through a Home Assistant log is about as exciting as watching paint dry. "Motion detected: Front Porch. 09:14 AM." Riveting stuff. You know something happened, but you feel absolutely nothing. Here's the thing: data shouldn't be a boring list. It should tell a story. A heatmap takes those lifeless "motion on/off" blips and paints a picture of *life*. You stop seeing timestamps and start seeing patterns: that 2 AM kitchen raid for a snack, the afternoon sunbeam that trips the living room sensor, the quiet stillness of a Tuesday when everyone's out. That's the power we're unlocking.

Step One: Stop Guessing, Start Storing

Home Assistant is brilliant at collecting data. But it's not built to be a long-term historian for heavy analytics. That's where InfluxDB comes in. Think of it as the super-organized, limitless filing cabinet for your sensor data. Setting it up sounds scary. It's not. It's a container you spin up, point Home Assistant at it, and forget. The magic happens in your HA configuration. You just tell it: "Hey, send all the state changes for my motion sensors to this InfluxDB address." From that moment on, every blip is saved, stamped, and ready for its close-up. No data left behind.

Cranking the Dial from "Chart" to "Heatmap"

Alright, data's flowing. Now for the fun part. We jump into Grafana (you're using that, right? It's basically the face of InfluxDB). You create a new Panel, and instead of a boring "Time Series" graph, you select "Heatmap." Here's where you get to be a data artist. The query is simple: count how many "on" states my motion sensor had, grouped by time of day. But the trick is in the *bucketing*. You split your day into, say, 30-minute chunks, and your week into days. The query does the math, assigning a "heat" value to each block—more motion in that block equals a hotter color. Suddenly, you're not plotting points. You're plotting intensity.

Reading the Thermal Footprints of Your Life

So you've got this gorgeous, colorful grid. What now? The story writes itself. That solid vertical band of red every weekday at 7 AM? That's the morning rush in the hallway. The faint, sporadic yellow blips in the living room between 10 PM and midnight? That's you, forgetting your phone charger. Again. A completely cold, blue column every Thursday afternoon? Ah, that's when the house is empty for cleaning. This isn't just "security" anymore. It's behavior analytics. You can spot anomalies—unexpected activity when the house should be empty. Or optimize your heating schedule to warm up the kitchen right before that morning heat starts to rise. The data shifts from reactive to predictive.

From "What Happened" to "Make It Happen"

Static graphs are cool for a minute. But the real magic is making them live. Grafana lets you set alerts on your heatmap data. See a hot spot forming in the backyard at 3 AM? That's an instant notification to your phone. You can even feed this long-term pattern data back into Home Assistant. Create an "Average Household Activity" sensor. If motion is detected but the heatmap says activity is historically near zero, that's a high-priority alert. Your automations get smarter because they understand context, not just instantaneous state. Your house stops just reacting. It starts anticipating.