Challenge #244: Cats and Dogs

[LHolmes]

I found this one pet-ticularly fun! Good reporting tools exercise.

Spoiler

[MerlinB]

Spoiler

[ErikaLoz]

my solution.

Spoiler

[Tyro_abc]

Spoiler

[AdhirKirtikar]

Spoiler

I had very tough time to get the correct density for some states. Figured out that I was using sq. kilometers instead of sq. miles 😂

[TonyA]

As always, it was tweaking the format that took all the time.

Spoiler

Especially positioning and sizing the legend using Report Map and Overlay. Also had some challenges with the data. The areas and pet populations were already in the input data. It did take me a while to figure out that the solution was using area in square miles and the data was in square meters. I spelled that out in comments in the Formula.

[SeanAdams]

Did anyone else get an odd behaviour of the Map tool where it worked well in the preview screen but when you run the canvas it just puts a bounding box?

Oh well - started again and it seemed to fix it.

Spoiler

[JustinBabbitt]

Thanks! 

Spoiler

[estherb47]

Meow! Woof! And soon to increase the household with pets percentage in NY.

Spoiler

Not pretty. In rush to complete loads of missed challenges mode at the moment

[PraphulSamavedam]

I would like to know how the state names were removed in the render map tool. Interested to learn about it.