Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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 #240: Every Vote Counts!

AYXAcademy
Alteryx
Alteryx

A solution to last week's challenge can be found hereRCV.png

 

This week's challenge was submitted by @AShapiro  - Thanks for your contribution!

 

What’s your favorite flavor of ice cream? Hard to choose just one? With ranked choice voting (RCV), you don’t have to! With RCV, you can rank your favorites in order of choice.

For this week’s challenge, we have the results of a Favorite Flavors of Ice Cream poll. Build a workflow to conduct a RCV to find the voters’ favorite flavor and the total number of voting rounds. If a flavor receives more than half of the first choices, that flavor wins. If not, the flavor with the fewest first choice votes is eliminated. For voters who picked that flavor as their “Number 1”, their votes shift to their next choice. The process continues until a flavor has more than half the votes. Click here for a video explanation of RCV.

Aaron_Harter
11 - Bolide

Great challenge, go VOTE!

Spoiler
1.2.PNG

 

(edit 11/02 11:00 CT) video of solution overview:

Spoiler
Greg_Murray
12 - Quasar

Go vote everyone! 

Spoiler
Greg_Murray_0-1604329845436.png

 

Spoiler
Greg_Murray_1-1604329887462.png

 

dsmdavid
11 - Bolide

If only all the elections were as undivisive as this one...


Spoiler
dsmdavid_0-1604331301817.png
dsmdavid_1-1604331349308.png

 

 

Jonathan-Sherman
15 - Aurora
15 - Aurora

Challenge 240 is done! I took an iterative macro approach as it made the most sense to me...

 

Workflow:

Spoiler
Jonathan-Sherman_0-1604332978077.png

 

Iterative Macro:

Spoiler
Jonathan-Sherman_1-1604333085322.png

 

phottovy
13 - Pulsar
13 - Pulsar

Vote!

 

Spoiler
Preprocessing:
240a.PNG
Macro:
240b.PNG

 

JennyMartin
9 - Comet
Spoiler
AWC240.PNGAWC240M.PNG

Fun topic, takes me back to my undergrad dissertation! My iterative macro skills were a bit rusty so I am very grateful for the challenge! Video solution here: https://www.youtube.com/watch?v=ANmJLJYqVHw&list=PL18SpOXDj-KMUD4YwWC5vZaUsIa7drxNZ&index=44

AngelosPachis
16 - Nebula

My solution for challenge #240 with an iterative macro approach. Go vote and buy yourselves a Chocolate ice-cream on your way home.

 

Workflow

 

Spoiler
Screenshot 2020-11-02 180033.jpg

Iterative Macro

 

Spoiler
Screenshot 2020-11-02 175945.jpg

 

ggruccio
ACE Emeritus
ACE Emeritus

Since I knew there were only a few rounds, I created simple logic that I copied over and over until it got to 50%.

 

Go out and vote!

 

Spoiler
ggruccio_0-1604340515169.png

 

patrick_digan
17 - Castor
17 - Castor

 

Spoiler
patrick_digan_1-1604342698576.png
patrick_digan_2-1604342853276.png