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