We’ve extended Inspire Early Bird Pricing until March 1. Register now and enjoy 20% off conference passes and 10% off training passes. P.S. Don’t forget to bring friends! When you sign up for five or more tickets, you get an extra 20% discount on conference passes. Learn more now.

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 #329: Near Earth Objects

ryanmorin
7 - Meteor
Spoiler
Screenshot 2022-07-25 185703.png

sergejs_kutkovics
8 - Asteroid
Spoiler

2022-07-26 08_56_06-Window.png
RWvanLeeuwen
11 - Bolide

Fun and easy to handle

Spoiler
329.png

 

Kaustubh17
8 - Asteroid

Hi @AYXAcademy 

 

Solution of Challenge 329

 

kaustubh17_0-1658821621233.png

Regards,

Kaustubh

 

AlexEntz
8 - Asteroid

Here is my Solution:

 

Spoiler
AlexEntz_0-1658827067246.png

 

rachel_lynch
Alteryx
Alteryx
Spoiler
rachel_lynch_0-1658834666774.png

 

Rachel Lynch
davidwyche
5 - Atom

For the first task, in the summation function, why do you (and apparently the solution), use a count instead of count distinct?  There are 23 id's/names repeated in the data set - the repeats all have the same years.  Why should a particular object be counted as a discovery more than once?

 

Using a count distinct I get 169

Clifford_Coon
11 - Bolide

My Solution

Spoiler
Callenge_329_Solution.jpg

harshendra
8 - Asteroid

My Solution

TiffanyD
Alteryx
Alteryx
Spoiler
TiffanyD_0-1658848122817.png