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 #273: Filling In The Blanks

Ellie_P
8 - Asteroid

Challenge completed😀

shawnmacnova21
7 - Meteor

Nice to work with a new tool! I don't get to use Generate Row much

 

Spoiler
shawnmacnova21_0-1625066234645.png

 

jagdeep_singh85
8 - Asteroid

PFA my solution

ncrlelia
11 - Bolide

Challenge 273

vikb03
8 - Asteroid

Took an alternative path to the solution!

 

Spoiler
Not as dynamic but wanted to practice with the multi-row tool!

vikb03_0-1625482958994.png

 

 

mbogusz
9 - Comet
Spoiler
Weekly Challenge #273 in the canWeekly Challenge #273 in the can
OllieClarke
15 - Aurora
15 - Aurora

Catching up after a break

Spoiler
OllieClarke_0-1625651658906.png

 

dhavaldoshi
8 - Asteroid

How to do it as a Beginner?

  • Creation of master data: Generate Rows and Right Outer Joins - could be a very useful tip working for KPIs if incase you are trying to account for 0s
  • Null vs 0s: This problem statement requires us to impede 0s, however remember there's a difference between 0 and a null
    Spoiler
    Solution_273.png
Elias_Nordlinder
11 - Bolide

My solution:

Spoiler
Elias_Nordlinder_0-1626251237497.png

 

xAJBx
7 - Meteor

Here's mine!