Hi Kirdan, you're going to need to export a packaged workbook, for us to be able to take a look. (It'll be a .twbx instead of a .twb)

--Shawn

As a fellow New Zealander I couldn't resist having a go at this.

I've done a few things to help with the mechanics - other people may have more suggestions on the most effective way to present it.

Getting the pages shelf to coordinate between the two sheets on the dashboard was just a matter of setting both to use the same time granularity - you had day for one and year for the other. I set them both to month (I was getting bored watching the paint dry with it set to day - even on the fastest setting).

I've changed both the bar chart and the colour of the dots on the map to be running sums, rather than just counts). That way you build up the cumulative picture. I also duplicated the running count of postcode from colour to size to emphasis the hotspots in the source of migration. That one in Blenheim, and to a lesser extent Nelson are suprising - is this real data?

I experimented with colouring the map by region. I tried a dual-axis map with a filled map coloured by region with your postcode dots overlaid - but the regional colouring tended to mask the dots. I also tried colouring the dots by region and relying on size for the number of migrants - but eventually decided that there was no need - the position of the dots on the map and the bar chart already convey that information twice - no need for a third way.

I also fiddled with the size scale settings a bit - otherwise the dots for single migrants from a postcode barely showed.

Kirdan, I started with Richard's version and added a few tweaks. Not being a fellow New Zealander, I was curious where these regions were, so I used color on both the bar chart and map to show this. I also added a reference line to the bar chart, as well as highlight actions to everything. And tweaked the layout a bit. BTW, interesting information. Here's what it looks like:

--Shawn

Hmmm - I don't see the pesky red exclamation mark on mine, yours or Shawn's.

About the only thing I can think of is that you are on 7.0.0, whereas Shawn and I are on 7.0.1 (I can see that by peeking at the XML of the workbooks). I wasn't aware of any issues in that space - but maybe this is a case where a workbook created with 7.0.1 doesn't work with 7.0.0.

It's probably worth trying upgrading. 7.0.1 seems pretty stable - I had one crash almost as soon as I installed it, which Tableau support say a few people have hit, but it's been solid since then.

I'm not quite sure I follow what you are trying to do with the running sum by year. I initially interpreted that as a side-effect of the calculation being broken - but having just read your comment to Shawn I'm not so sure.

Maybe try 7.0.1 and let us know if that fixed the red exclamation mark - and also if you're still having an issue with the running sum maybe post some screenshots showing what's happening.

Glad that 7.0.1 fixed your pesky red exclamation mark. That's interesting, though, I don't ever recall seeing incompatibilities between workbooks created with different minor releases like that before.

Where do you work out of?

Kirdan, Placitas (near Santa Fe) NM, USA. I do data viz consulting for my wife's advertising agency. How about you? What industry/job do you use Tableau for?

--Shawn