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. 

スポイラ
jarrod_0-1593799312007.png

 

 

CHerv
メテオール

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.

 

スポイラ
CHerv_0-1593871799146.png

 

DBoyer
メテオール

Not the most concise, but attached is my solution.

tammybrown_tds
コメット

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.

 

スポイラ
Challenge 63.JPG
mag161
アステロイド

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

Rima1776
アステロイド

Solution Attached

alynnreau
アステロイド

Challenge #63

Followed along with solution

Arturo90
メテオール

Hi! This is my solution

luisalfonsoperez
メテオール

My solution

Sharmila_4
アトム

Here is my solution