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!

lpvlinh
7 - Meteor
Spoiler
lpvlinh_0-1635858634345.png

It took me a while to figure out that i need to use 3 cross tabs to basically create 3 table and merge them together. The convention is very different from Power BI.

kunderwood
8 - Asteroid

Two aspects I loved about this challenges was using a batch macro to create subtotal rows and using the dynamic rename tool to remove those annoying "Sum_ " prefixes from column headers!!!!

 

Enjoy fellow Alteryx peeps. 😊

Spoiler
kunderwood_0-1635861201323.png

 

kunderwood
8 - Asteroid

Nice use of the imputation tools my friend!

phottovy
13 - Pulsar
13 - Pulsar

My solution:

 

Spoiler
292.png
joelmiller66
9 - Comet
Spoiler
Challenge 292 Image.png
danettedavis
8 - Asteroid

solved

Toons
12 - Quasar

My solution :

 

Spoiler
Toons_0-1635878777384.png

 

ryan-bush
Alteryx
Alteryx
Spoiler
ryanbush_0-1635884496072.png

 

Awesome data manipulation challenge!

Justin_B
8 - Asteroid

I'm sure there's a better way!

Spoiler
justin_butler_0-1635885938701.png

 

binuacs
20 - Arcturus
Spoiler
binuacs_0-1635890756494.png