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 #363: Coffee or Tea? That’s the question.

AYXAcademy
Alteryx
Alteryx

A solution to last week’s challenge can be found here. 

 

To solve this week’s challenge, use Designer Desktop or Designer Cloud Trifacta Classic. Image_Coffee_Tea.png

 

According to the Harvard School of Public Health, tea and coffee are the two most consumed beverages on the planet after water. They are brimming with antioxidants and other biologically active substances that may benefit your health.  

 

For this week's challenge, we will use a dataset containing information about the sales of coffee and tea in the USA for a 6-month period.  

 

Based on the sales of each product, determine the following: 

 

  1. Which state is the biggest consumer of regular coffee?
  2. Which state is the biggest consumer of decaf coffee?
  3. What type of coffee drink is the most popular?
  4. Which state is the biggest consumer of regular tea?
  5. Which state is the biggest consumer of decaf tea?
  6. What type of tea drink is the most popular?

 

Source: https://data.world/2918diy/coffee-chain 

BS_THE_ANALYST
13 - Pulsar

Coffee/Tea enthusiast 😏. Love this challenge 😎

Spoiler
BS_THE_ANALYST_0-1679325125125.png

 

Flo_P
8 - Asteroid
Spoiler
Feel like this is inefficient. But I always have that feeling, so.
Flo_P_0-1679325490344.png

 

binuacs
20 - Arcturus
Spoiler
binuacs_0-1679325997002.png

 

Kenda
16 - Nebula
16 - Nebula
Spoiler
Kenda_1-1679326157481.png

 


 

Towers
11 - Bolide

got it!

Spoiler
Towers_0-1679326287489.png Edit: a more refined solution Towers_0-1679326865803.png

 

 

NathanDavis
5 - Atom

I'm quite new to Alteryx so any feedback would be great 😊

Spoiler
NathanDavis_1-1679326441987.png



ahsanaali
11 - Bolide
Spoiler
ahsanaali_0-1679327077354.png

 

TurboToad
9 - Comet

Fun challenge!

Spoiler
TurboToad_0-1679327421607.png

 

elaineyuan
8 - Asteroid

Happy Monday! 🍵

 

Spoiler
challenge_363_elaine_yuan.png