Correlation by efficency and sum by day with R script

So i went ahead and solved it as a new table. It's a bit cumbersome of a solution and i'd much prefer it if there was a better way of passing it directly into R formated as you have in power bi. I couldn't find one though. If you're like me and new with this and use a lot of filters like me there's either M or "in" and "Contains". It works at least.

I noticed something odd with trend lines as i was testing it. It wouldn't let me use trend lines with x and y's alone. Had to use detail field even if it did not change the scatterplot in any way.