I have seen three ways to do waveform overlay to look for relationships. Each has its own challenges:
- Home Assistant with Sense Integration - requires free Home Assistant and a platform to run it on along, plus a little IT system knowhow. Here’s an example of an overlay using data from Sense - I have charted Total Usage overlaid with the native detections for both our EVs, plus a separate DCM-measured view of the Model 3 charging.
- Sense Data Export with Excel or another tool - A little limited because the minimum increment for export is 1 hour, plus you’ll need to deal with missing hours. But entirely possible with a little knowledge of Excel and Pivot Tables. Here’s the same power usage overlay of the two Model 3 devices I show above, done with Sense Data Export and Excel.
BTW - I have to show as an Excel bar chart because when I switch to a line chart, the two lines exactly overlay each other (but they are the same data, one from Sense native detection and one measured)
I’ll add how to do this in Excel in the comments below.
- Graphical Overlay - Requires a graphic editing program. explained here.