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 #102: Tabulating Flu Data

Here is my first challenge solution. I was able to use one less tool than shown in the solution.

ozdogand
8 - Asteroid

here you go..

Spoiler
ozdogand_0-1576689808325.png
Steph3388
7 - Meteor

Did things a little different:

blairmbailey
8 - Asteroid

Edit: Attached a solution and realized I already submitted one for this... Whoops!

Hjardine
8 - Asteroid
Spoiler
Hjardine_0-1577123326041.png
Skip 1st 2 rows and then rename the columns. Change weekly rate to double for calculation and then cross tab for columns. 
djodts
8 - Asteroid

Here's my solution

joshuaburkhow
ACE Emeritus
ACE Emeritus
 
Joshua Burkhow - Alteryx Ace | Global Alteryx Architect @PwC | Blogger @ AlterTricks
JamesCameron
8 - Asteroid

My Effort

 

Spoiler
JamesCameron_0-1577803207546.png
echuong1
Alteryx Alumni (Retired)

Hoping not to get the flu this year! 

 

Spoiler
echuong1_0-1578079465970.png
Jess2
6 - Meteoroid

Here is my solution.