Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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.