Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

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 #49: Reformatting Transactional Data

HardikJani
アステロイド

I first split all the product, market and type then used a combination of cross tab and append to get the data for each of the letters A,B,C,D. And then joined them using union. King of basic solution but I love looking at better solutions to learn from them.

Spurs
アステロイド
スポイラ
Spurs_0-1681914119390.png

 

Arjunmarwaha09
アステロイド
スポイラ

There goes challenge_49

49.PNG




Ray_Pospisil
アステロイド

nice transpose/cross tab exercise

scooby_snacks
アステロイド

My solution. 

Goddenra
アステロイド

Good practice of cross tabs which is always a bit of a tricky thing for me.

mshahid
メテオール

Challenge 49 Completed

mshahid
メテオール

Challenge 58 Completed

AImbody
アステロイド
スポイラ
AImbody_0-1683294248449.png

 

helenxu1975
メテオロイド
スポイラ
helenxu1975_0-1683366920010.png