Hey @Darren wow I'm really sorry about the late reply on this! As complexities grew for this dashboard, I ended up learning about and creating a custom component library for our org so we could implement this data into a custom component.
Custom components are definitely the power we needed to be able to return relative keys from nested collapsible table rows to retrieve and calculate all the detailed aggregated metrics we needed for our performance graphs!
I really appreciate you both following up! 