Rody Zakovich created a polygon-based hex map because he found that the shape-based hex map (created by Matt Chambers) can be hard to align and scale.

By looking into Rody's template, I found something to tweak. I created here two versions of the hex map. Both uses smaller data sizes. Note that originally each hexagon needs 6 points thus 6 rows of data. Here you go.

1.Label without extra 51 rows 

Rody used an extra 51 rows solely for the state labels. I found a way to label without the extra rows.

First, drag avg(X) and avg(Y) to Columns and Rows shelves respectively with State in Details and Point in Path, while the data mark is Polygon.

Second, use avg(Y) for the vertical position of the label. Put Abbreviation in Label shelf. So we get the labels right in the middle.

Recently I was invited to give a talk at PASS http://www.pass.org a non-profit organization of database professionals. Here is the video.
Blog Archive
Loading
Dynamic Views theme. Powered by Blogger. Report Abuse.