Whack Data     About     Archive     RSS

Mapping Pokemon by Their Rarity

At long last, I’ve added a simple patch that lets you group Pokemon by rarity in Pokelyzer! (Thanks Niklas and ferazambuja for the help!)

If you’re just joining, have a look at Finding Hotpots for Locally Rare Pokemon Using Tableau and Help Others Find Rare Pokemon Nearby before continuing.

And if you already have Pokelyzer set up, have a look at the latest patches in the readme and install the new webhook listener which you’ll need before continuing.

One last thing: if you Tableau trial is running out, have a look at this PowerBI tutorial put together by /u/daymanelite. It’s still young, but it looks very promising.

This one’s gonna be quick, so let’s jump in.

After you apply the newest pokemon_info table patch, go to the Data Sources tab, go to the Data menu, and click Refresh.

Go back to one of your worksheets and check your pokemon_info table and you should find a new entry for rarity.

If you have an red Name fields like the following showing, let me explain.

In the latest release, the name field became redundant because it was in the pokemon_info table as well, which we can just join to our main spotted_pokemon table based on the pokemon_id field. This is good practice because if the spelling gets messed up on one of the Pokemon’s names (it happens), instead of having to edit hundreds of thousands of rows in the database, you update one line of the pokemon_info table. Easy and efficient.

To fix the red field, just drag the name field from the pokemon_info table over top of it, and all should be better.

Now just duplicate the map you made in Help Others Find Rare Pokemon Nearby. Drag the rarity field over top of the current filter to replace it.

Check all the boxes in the dialog that comes up, and click ok.

Right-click the filter, select “Show filter”, and change the dropdown to “Single value (list)”.

Select the button for “rare”, and there you go! Only the rare ones show up on the map.

Just to be sure you have good data since the the nest switch, see my post The Era of Eras - Updating Pokelyzer for the Nest Switch-a-Roo and add a filter for Era.

Finally, drag the Pokemon name over the Color box and again over the Label box (drag twice from the left menu or it’ll just move it). You’ll now have all the points colored and labelled.

If you want, click the Label area and adjust the setting as you see fit.

Next Up…

I would still like to do some tutorials on time-based analysis, but I’m actually waiting until after I finish the next major addition to Pokelyzer, which is support for local timezones. Timezones are tougher than they sounds (check out my explanation here if you’re interested), but I’ll hopefully have that out the door in the next few days. Stay tuned!