Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #152: Finding Vehicle Counts

Highlighted
7 - Meteor
 
Highlighted
8 - Asteroid
 
Highlighted
8 - Asteroid

Did it both ways, using a summarize tool and without.

Highlighted
8 - Asteroid

My Effort

 

Spoiler
JamesCameron_0-1580833146055.png
Highlighted
8 - Asteroid

My Effort

 

Spoiler
JamesCameron_0-1580833146055.png
Highlighted
7 - Meteor
Spoiler
Solution
Highlighted
9 - Comet

I was about to post a solution and then spotted the no summarise rule!

 

Actual solution:

 

Spoiler
 

 

 

Original attempt:

Spoiler
tonyp_2-1581598228713.png

 

Highlighted
8 - Asteroid
Spoiler
I tried to do as much with calgary tools as possible but didn't manage to get the final solution without non-calgary tools... so here's my approach. Still not sure what is happening but, hey, it works

image.png
Highlighted
8 - Asteroid
Spoiler
Challenge 152 2020-02-17.jpg
Highlighted
Alteryx Partner

First time using Calgary tools. Two approaches, the one I thought more obvious doesn't return all the fields needed.

Spoiler
dsmdavid_0-1582581541169.png