Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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 #112: Organizing Survey Data

cplewis90
13 - Pulsar
13 - Pulsar

My solution that would have to be altered if the # of questions changed and could probably be altered into a macro to accommodate that.

Spoiler
I added an extra input with the column headers and then joined on record id(finally found a good use case for that option!!) Really digging the make columns tool within Laboratory! It has become a very useful tool!Challenge 112.JPG
danrh
13 - Pulsar

 

Spoiler
image.png

 

neilgallen
12 - Quasar

Ugly. Way too direct and manual. But it works. Don't judge me it's late.

Ruud
10 - Fireball

I tried to be lazy and ended up with something that should never see the light of production, ever.

KeithZ
8 - Asteroid
Spoiler
survey.png
svenk
8 - Asteroid

My Solution!

danilang
19 - Altair
19 - Altair

Tricky

Spoiler
DanSolution 112.png
MarcusDoesBI
7 - Meteor

Took a moment but got there in the end. Concatenate in Summarise Tool FTW!

 

 

Spoiler
Challenge 112 - Survey Data.PNG
myastarling
10 - Fireball

Here's my solutions -- one with Regex replace, one without. I took a look at other people's solutions and I like the use of Record ID for transposing/cross-tabbing! Wish I had thought of that!

JosephSerpis
17 - Castor
17 - Castor

Challenge Completed