Knowledge + Science

The next put up is a visitor put up by Peter Fakan, Tableau Developer on the Australian Institute of Well being and Welfare.

9/20/2017

Switching Map Shapefiles Utilizing Parameters and Calculated Fields

I’m positive all of us have tales to inform about utilizing spatial knowledge in Tableau. Even Tableau is at present considering discovering out extra about customers experiences with mapping here. Tableau 10.2 launched shapefiles as a brand new knowledge supply kind. On this put up, we’ll discover utilizing multiple shapefile inside your viz and swapping them with a parameter. Alan Eldridge has the same put up of this subject here.

Listed below are the steps wanted to change shapefiles utilizing a parameter.

Step 1: Load the Shapefiles

Step 2: Create a Parameter

This parameter will permit the consumer to pick out completely different geographies.

Step 3: Create a Calculated Discipline

This calculated area accumulates all the completely different geometry fields from the shapefiles, managed by the parameter.

Calculated Discipline Title: Map

Formulation:

<br /> IF [Parameters].[Map] = « 1 » THEN COLLECT([Geometry]) <br /> ELSEIF [Parameters].[Map]= « 2 » THEN COLLECT([SA2_2016_AUST].[Geometry]) <br /> ELSEIF [Parameters].[Map]= « 3 » THEN COLLECT([SA3_2016_AUST].[Geometry]) <br /> ELSEIF [Parameters].[Map]= « 4 » THEN COLLECT([SA4_2016_AUST].[Geometry]) <br /> END <br />

Step 4: Construct the Viz

Drop the brand new calculated area into the marks space of your viz on Particulars. On this instance, I’ve additionally used the frequent area Ste Name16 on Coloration, to create frequent shade throughout all 4 mapfiles. Don’t overlook to point out the parameter management.

You must now have a visualization that may interactively change the mapping geography. As a phrase of warning this could create extraordinarily massive knowledge information (the scale of those shapefiles used on this instance alone is 69mb) which is able to have an effect on efficiency, however should you occur to know a pleasant GIS developer you may ask them to simplify your shapefiles to take away extraneous vertices which can assist just a little.

You can provide the viz a attempt to obtain it from here.

– Peter Fakan

An enormous because of Peter Fakan for penning this weblog put up and constructing a pattern workbook. I hope you discover this info helpful. You probably have any questions be at liberty to electronic mail me at Jeff@DataPlusScience.com

Jeffrey A. Shaffer

Comply with on Twitter @HighVizAbility