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

AndrewHoData
8 - Asteroid

Never heard of a 

Spoiler
Calgary input 

until now. Workflow below

Spoiler
AndrewHoData_0-1676863086975.png

 

 

leonhekkert
8 - Asteroid

My solution:

 

Spoiler
challenge_152.png
kristiadiuisan
8 - Asteroid
Spoiler
Alteryx_challenge_152_KU.png
dougbaron
8 - Asteroid

pretty easy

Spoiler
dougbaron_0-1679597470742.png

 

alacoume
8 - Asteroid

My solution:

ale_sisto
7 - Meteor

My solution:

chandler-gjino
Alteryx
Alteryx

attaching my solution

ed_hayter
12 - Quasar
Spoiler
ed_hayter_0-1687344506699.png

Never new about the Calgary Tools - very interesting. Opted not to use the count records macro as it contains a summarize so went with a running sum and sample the last row. I built my query in the input to only return blue chevys

rachel_lynch
Alteryx
Alteryx
Spoiler
 

Result.png

 

Rachel Lynch
MitchellBliesner
8 - Asteroid

Here is my solution. I can't post a screenshot into a spoiler tab for some reason. I don't know if anyone else is having that problem.