Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Weekly Challenges

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

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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

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

Michael_McKee
Alteryx Alumni (Retired)
Spoiler
Capture.PNG

BMorgan1390
8 - Asteroid

GOOOOAAAAAALLLLLLL!!!!

swelday007
5 - Atom

My first Weekly Challenge complete!

Spoiler
swelday007_0-1637187518731.pngswelday007_1-1637187552333.png

 

 

Jana_Nandakumar
7 - Meteor

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
8 - Asteroid

Here is my take 🙂

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

kelly_gilbert
13 - Pulsar

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