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.
2022.1.1.30569 Patch Release Update

The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs. If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.

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 #308: Size it up

benjamin_feuchter
8 - Asteroid

Resulting percentages based on 1839 rows - I don't think dividing by 1850 is the right approach here.

Spoiler
benjamin_feuchter_1-1647443355550.png

 

 

 

MichMatt
8 - Asteroid

My solution.

Shawn_Maphoto
7 - Meteor

Hi All, here is my solution

Spoiler
weekly challenge_308_SM.PNG
leonhekkert
8 - Asteroid
Spoiler
Challenge_308.png
Diederik_vanderharst
8 - Asteroid

Voila

Spoiler
Schermafbeelding 2022-03-24 om 09.31.43.png

Shifty
12 - Quasar

For the life of me I can't get the same percentages but I can't see where I've gone wrong! 😬

Spoiler
Shifty_0-1648130419655.png

 

tammybrown_tds
8 - Asteroid

@Shifty,

 

I had the same issue.  The solution in the output uses the SmartRound formula (exactly what you have, except the [Count by Size]/[Total Entries] part of the equation is enclosed by the SmartRound function).  if you do that, your percentages will match the solution.

 

I was never able to fully determine what the SmartRound function does, but it's the only way that the results match the output set.

Shifty
12 - Quasar

Thanks, @tammybrown_tds - I'll take a look at that.  My solution was never going to be "SMART". 🤣🤣

Spoiler
HarleyBarnes_Quantium_0-1648444084025.png

 

BSilverblatt
8 - Asteroid

Thanks for the challenge! Here's my solution: