Challenge #152: Finding Vehicle Counts

[maheensayeed]

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

[JamesCameron]

My Effort

Spoiler

[JamesCameron]

My Effort

Spoiler

[black28]

Spoiler

Solution

[tonypreece]

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

Actual solution:

Spoiler

Original attempt:

Spoiler

[hanykowska]

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

[danicahui]

Spoiler

[dsmdavid]

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

Spoiler