6 Replies Latest reply on Nov 30, 2016 3:10 PM by Payam Ghadirian Branched from an earlier discussion.

# Re: Combining a Polygon Map with a Point Map

Hi Yuriy,

I have a somehow similar question. I managed to combine two data sets (one polygons and other one points) but no luck in overlaying them. Will be great if you can help!

Thanks

Payam

• ###### 1. Re: Combining a Polygon Map with a Point Map

Hi Payam,

I've branched your post as a new Question.

The original thread is not yet closed,

so it is not wise to mix two questions.

It's great that you've get all data as a single source.

To get both polygons and points on a single map,

you have to manage having only one pair of Lat / Lon per view.

You could make calculated Lat / Lon fields like this (Lat for example):

IF ISNULL([Orig Fid]) THEN [Lat] ELSE [Y Lat] END

Then using these calculated Lat / Lon fields your could build a Dual-Axis Map.

Hope this could help.

If not, the sample workbook from you would be help a lot.

Yours,

Yuri

• ###### 2. Re: Combining a Polygon Map with a Point Map

Hi there I also had some great assistance from Yuriy and the way I got it fixed was to have a common field in both sets of data - for the points and the polygons. Then created a union in the data tab, which allowed me to add the second layer on a dual axis map as mentioned above.

This is what I ended up with.............

• ###### 3. Re: Combining a Polygon Map with a Point Map

Hi Yuriy,

Thanks a lot for your reply. I created the calculated lat and long as advised but no luck with overlaying points over/around my polygons.

I attach the workbook for you to have a look.

Thanks again,

Payam

• ###### 4. Re: Combining a Polygon Map with a Point Map

Thanks Naresh,

Nice map! hope I can create mine soon!

Cheers

Payam

• ###### 5. Re: Combining a Polygon Map with a Point Map

Hi Payam,

The trick is to use Lat / Lon as Measures with AVG aggregation.

For this one should have Aggregate Measures flag set to ON.

Also, for the Dual Axis (Polygon / Point) map there are points

(typically averaged into the "middle" of a map) which comes from

the "polygon" rows of the combined datasource. They are there,

and there is no way to filter them out (without distorting a Poly pane).

So I used visual clues in Size and Color for you to see these points.

You should decide how to deal with them (grey color, min size, distinct shape may be).

Hope this could help.

Yours,

Yuri

so you could use my correct answer as a guide, too.

• ###### 6. Re: Combining a Polygon Map with a Point Map

Hi Yuriy,

Many thanks for the clever solution. It looks great.

I will try to replicate your solution with my data and get back to you.

Thanks again,

Payam