3 Replies Latest reply on Aug 24, 2016 4:45 PM by Yuriy Fal

# Generating Latitude / Longitude from non-uniform data.

I have a data set that contains the following fields.

Name

City

State

Country

Here's some data.

Plant A

Burlington

VT

USA

Plant B

Los Angeles

CA

USA

Plant C

London

None

UK

Plant D

Berlin

None

Germany

If I drag city and country to the marks bar, I get the two non-US entries to show up on the map.

If I add State, then those two disappear, and the two US entries show up. Errors are thrown for the two European ones, since State doesn't match.

How can I get both of these to show on one map?

Tableau 10 Desktop

Thanks.

• ###### 1. Re: Generating Latitude / Longitude from non-uniform data.

Hi Christopher,

Tricky, but doable.

Yours,

Yuri

• ###### 2. Re: Generating Latitude / Longitude from non-uniform data.

Wow. That works.

You are right, that is tricky.

What does the split latitude pill mean? I've never seen that before.

I see that something is going on with the index, but can't figure out what.

• ###### 3. Re: Generating Latitude / Longitude from non-uniform data.

Split Lat mean Dual Axis.

So there are two maps actually, each one with their own Marks.

Also you could see two distinct Marks shelves. Three shelves, actually.

And the Pills are different on each shelf. So are the Marks on each Pane.

The Table Calculation INDEX() Filter effectively "hides"

just one of the duplicated Marks for the Plant B (LA) --

those on the leftmost Lat pill (backmost map) Pane,

so only 4 Marks on both Panes are left (instead of 5).

And you could see the 3 Nulls (as indicated in the lower right).

So the total (potential) number of Marks would be 2 x 4 == 8.

To leave only 4 marks on a view, i've created INDEX() calculation

by typing right in the Marks shelf of those leftmost Lat green pill

(this is the upper shelf from the two). After setting the Addressing (Compute using),

I've moved the pill onto the Filters shelf and "hide" the mark with INDEX() = 3. That was it.

Hope this could help.

Yours,

Yuri

1 of 1 people found this helpful