How Many Rats Are Near Hungry Cat?

Well, I don't really mean near YOU, I mean near people that live in New York. One of the fun datasets we play with at The Data School when I'm teaching them spatial analytics is Rat Sightings in New York.

And right after I taught this class to DS16, Lorna Eden posted the Workout Wednesday week 43 challenge. In this challenge, you had to find all casinos within X miles of a casino you click on. This required using the new DISTANCE function that came into Tableau 2019.3.1.

So, why not practice this technique more, but with rats? Instead of clicking on a casino, you can click on a rat to make it the Hungry Cat and find all rats within X miles of the cat. Silly, yes, and fun to practice too. The rats all have names too.

Lastly, I wanted to resize the dots based on the number of rats in the view. I used this blog post from The Data School, except I used an LOD instead of a table calc.

Enjoy! Find the rats near you.