alteryx Community

# 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.

## Challenge #240: Every Vote Counts!

Alteryx

A solution to last week's challenge can be found here

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.

11 - Bolide

Great challenge, go VOTE!

Spoiler

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

Spoiler
12 - Quasar

Go vote everyone!

Spoiler

Spoiler

11 - Bolide

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

Spoiler

15 - Aurora

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

Workflow:

Spoiler

Iterative Macro:

Spoiler

13 - Pulsar

Vote!

Spoiler
Preprocessing:

Macro:

9 - Comet
Spoiler

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

Find the challenge here: https://community.alteryx.com/t5/Weekly-Challenge/Challenge-240-Every-Vote-Counts/td-p/659897
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

Iterative Macro

Spoiler

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

17 - Castor

Spoiler