We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #292: It's about Pivoting, Prepping and Reporting!

Michael_McKee
Alteryx
Alteryx
Spoiler
Capture.PNG

BMorgan1390
7 - Meteor

GOOOOAAAAAALLLLLLL!!!!

swelday007
5 - Atom

My first Weekly Challenge complete!

Spoiler
swelday007_0-1637187518731.pngswelday007_1-1637187552333.png

 

 

Jana_Nandakumar
6 - Meteoroid

Late post, but learnt Pivot and table..

jaheath
6 - Meteoroid

Thanks for the helpful video, well done! I was stuck before I watched your video. I did notice that the grand totals were doubled in each case, though. I moved the summary tool to earlier in the work flow and it looks like that worked so it didn't double count.

 

jaheath_0-1637597971552.png

 

 

PhilBalderson
8 - Asteroid

First weekly challenge completed on my M1 Mac. The Mac was faster than I was. 

 

Spoiler
292_spoiler.png
gun_ho_park
7 - Meteor
Spoiler
292_solution.png
anabelvelazque
5 - Atom

Here is my take 🙂

Credits to Philip Mannering (I liked the way the challenge was solved!)

kelly_gilbert
12 - Quasar

This was a great challenge - thank you, @binuacs! I don't think I've ever had a requirement to include subtotals in a table, so it was a good puzzle to solve.

 

Output:

kelly_gilbert_1-1638155084717.png

 

Workflow:

Spoiler
kelly_gilbert_0-1638154999469.png

 

dsmdavid
11 - Bolide
Spoiler
I never quite remember how to use the cross tab to spit totals too, so...
Capture.PNGEngine_10396_845b9f004c474cd0a74ea003002bb1d9_.png