Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAI tried my best to come up with a solution for this -- I looked at the provided solution and I honestly don't see how we are supposed to arrive at that given the provided instructions. I also don't know much about football. With that said, here's my college try.
Had fun using the new (to me) Rank tool in this! I took the non-beginner route and calculated the die rolls. I also designed it so the workflow randomly matches up two teams since I know nothing about footy-ball. 🤣
I was really unclear about how to incorporate the Multiplier into the prediction. I looked at the Alteryx Solution but that didn't help - I'm unclear why that random Multi-Row difference field was added. I looked at other people's solutions and they seemed to solve this in a variety of ways, so eventually I just scrapped the Multiplier piece and randomly picked Catch vs Drop for the outcome, without the dice Multiplier at all.
Not sure if I got this one right but I have an answer influenced by the dice roll either way