Can I join across sibling data? I'm trying to reach the same type of data transform that I can with group-by. Short example of where I am now:

https://gist.github.com/JJ-Atkinson/87f7b7edcd4157af3364297bbab4c880