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

My solution is attached.

Nice 🙂

Challenge 192 is done, and in just 4 tools too! (excluding text input)

challenge 192 JMS solution.PNG

I used the fact that 1 + Null = Null, so when I pivoted my data, grouped by date and crane names as column headers, all I had to do was sum the row then filter for non-null values. But a lot of other solutions used fewer tools than I did, so maybe I'm not that clever after all. 🙂

Finally we get to do some analytics on the business fundamentals of Bob-the-builder's new enterprise! 🙂

Used a generate rows to blow the date ranges out into unique dates.
From there it's just a matter of counting.

Used a generate rows to blow the date ranges out into unique dates.From there it's just a matter of counting.

Attached is my solution.

I'm sure I didn't take the easiest path possible but my brain is already on christmas I think

192 solution.PNG

Reminds me of one of the Inspire Challenges

curated machine learning resources