Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #102: Tabulating Flu Data

Highlighted
6 - Meteoroid

Thanks for the solution.

How did you calculate the values? The data type should be numeric to get the summation of Weekly Rates, but the Weekly Rate has data type V_String.

Highlighted
7 - Meteor

Took some inspiration from other spoilers and was able to come up with a solution. 

 

 

Highlighted
8 - Asteroid

Done

Spoiler
Milanz_0-1589311173767.png

 

Highlighted
7 - Meteor

I'm not privy to formatting on the community but how do you create the spoiler drop down?

Highlighted
7 - Meteor

I attached my solution below:

Highlighted
8 - Asteroid

Hi,

 

Attached my solution.

 

Best,

 

G

Highlighted
Alteryx Partner

My solution

Highlighted
7 - Meteor

Really enjoyed this one!  Does anyone have suggestions on maintaining the integrity of the column names and not allowing the Cross Tab function to separate values by an underscore?  Love to hear your thoughts!

Spoiler
102.PNG

Highlighted
8 - Asteroid

Not too hard. Anyone got a read on what the "Overall" column is supposed to capture, or any thoughts on why the exercise excludes it?

 

Tberney_0-1589839678748.png

 

Highlighted
Alteryx Community Team
Alteryx Community Team
Spoiler
Weekly Challenge 102.PNG