Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
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 #63: Data Preperation Using Pivot Tools

jarrod
ACE Emeritus
ACE Emeritus

went a slightly brute force way with this one, but it still scales out to new fields. 

Spoiler
jarrod_0-1593799312007.png

 

 

CHerv
Meteor

This was a challenge!! I thought I was missing something obvious (and probably am) but I good to see other solutions took a number of tools to get to the answer.

 

Spoiler
CHerv_0-1593871799146.png

 

DBoyer
Meteor

Not the most concise, but attached is my solution.

A few more formatting tools than most of the other solutions, but I got there; including an extra step to recalculate the Total for the dates of 04/24/2016.

 

Spoiler
Challenge 63.JPG
mag161
Asteroid

Not my best work. I am going to look at other's solutions since I am interested in how others approached it.

Rima1776
Asteroid

Solution Attached

alynnreau
Asteroid

Challenge #63

Followed along with solution

Arturo90
Meteor

Hi! This is my solution

My solution

Sharmila_4
Atom

Here is my solution