In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities 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 #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
7 - 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
7 - Meteor

Not the most concise, but attached is my solution.

tammybrown_tds
9 - Comet

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
8 - Asteroid

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

Rima1776
8 - Asteroid

Solution Attached

alynnreau
8 - Asteroid

Challenge #63

Followed along with solution

Arturo90
7 - Meteor

Hi! This is my solution

luisalfonsoperez
7 - Meteor

My solution

Sharmila_4
5 - Atom

Here is my solution