Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAYeah, still not very good at these.
A little under 8 minutes, what with the fumbling about with the grouping on the sum tools like a drunken toddler. (NOTE: Don't give alcohol to toddlers. If you needed that warning, you probably shouldn't have a toddler.)
I've been pivoting a lot recently. I often use crosstab and transpose combinations to replace joins if the fields are dynamic...
M.
Bit of a messy one to work with/make neat, however we got there!
Was actually a really nice challenge for trying new tools (like Pearson correlation) and also doing multiple tasks with one input!
My solution!