The Alteryx Community is a finalist in three 2026 CMX Awards! Help us win Customer Support Community, Most Engaged Community, and User Group Program of the Year - vote now! (it only takes about 2 minutes) before January 9.
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests Early 2026. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more here
Start Free Trial

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
15 - Aurora
15 - Aurora

Coffee/Tea enthusiast 😏. Love this challenge 😎

スポイラ
BS_THE_ANALYST_0-1679325125125.png

 

All the best,
BS

LinkedIN

Bulien
Flo_P
コメット
スポイラ
Feel like this is inefficient. But I always have that feeling, so.
Flo_P_0-1679325490344.png

 

binu_acs
ポラリス
スポイラ
binuacs_0-1679325997002.png

 

Kenda
16 - Nebula
16 - Nebula
スポイラ
Kenda_1-1679326157481.png

 


 

Towers
ボリード

got it!

スポイラ
Towers_0-1679326287489.png Edit: a more refined solution Towers_0-1679326865803.png

 

 

NathanDavis
アトム

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

スポイラ
NathanDavis_1-1679326441987.png



ahsanaali
ボリード
スポイラ
ahsanaali_0-1679327077354.png

 

TurboToad
ボリード

Fun challenge!

スポイラ
TurboToad_0-1679327421607.png

 

elaineyuan
アステロイド

Happy Monday! 🍵

 

スポイラ
challenge_363_elaine_yuan.png