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 #152: Finding Vehicle Counts

Si-Pri
8 - Asteroid
 
payam2
8 - Asteroid

Getting ready for Inspire Europe conference!

paulburrows
8 - Asteroid

My solution

Karam
8 - Asteroid

Nice to see the Calgary tools in practice!

 

Spoiler
Challenge 152.PNG
Inactive User
Not applicable
 
OllieClarke
15 - Aurora
15 - Aurora

Never really used the Calgary tools before

Spoiler
Challenge 152.png
TonyAdam
8 - Asteroid

Strange tools...

SueDonim
8 - Asteroid

Guessed it was C Springs - but figured it out, eh.

 

Spoiler
Process
- Calgary input
- Join on Region / Region Code
- Filter for Blue Chevys in Region 8
- Clean-up
- Add Record ID
- Take last Record ID (same as count)
- Set uppercase
- Clean-up

MySolution.PNG
AllieW
6 - Meteoroid

I've never used the Calgary tools before so this was an interesting one!

 

Spoiler
GypsymHills.PNG
markcurry
12 - Quasar
Spoiler
Solution.png