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 #272: Configure It Out

dhavaldoshi
8 - Asteroid

Tips for a beginner:

  • It can be difficult to understand how tools need to be configured, but this is one of the best examples of how a report can be generated
  • Layout + Join can always be replaced with Visual Layout - waiting for it to come out of Beta Program
Spoiler
Solution_272.png
Luke_C
17 - Castor
Spoiler
Luke_C_0-1625837072877.png

 

carmenrapariz
8 - Asteroid
Spoiler
Challenge 272.PNG
TheOC
15 - Aurora
15 - Aurora

Quite Harsh for a beginner challenge, but a really fun one too!

Spoiler
TheOC_0-1626189951134.png

 


Bulien
mceleavey
17 - Castor
17 - Castor

The reporting tools hurt my pancreas.

 

Spoiler
This was fiddly, but I did like the determination of the total goals contribution being calculated and then joined back. You really needed to understand that part before moving forward.

mceleavey_0-1626190771446.png

 



After that, it's just using the reporting tools, and they all hate me.

I got there eventually though.

M.



Bulien

Elias_Nordlinder
11 - Bolide

Fun challenge 🙂

 

Spoiler
Elias_Nordlinder_0-1626272670503.png

Most difficult part was to create the "Goal plus assist" with Cross Tab + Summarize Tool.

KilianL
Alteryx Alumni (Retired)

Some nice plays with the transpose and summarize tool, the Join is not even needed, so I 'disabled' it.

 

Spoiler
272 - Configure It Out - Kilian.png
ywang7
7 - Meteor

 

 

randreag
11 - Bolide

here my solution

Michael_McKee
Alteryx Alumni (Retired)

I learned a lot on this one.