1 2 Previous Next 26 Replies Latest reply on Apr 21, 2016 12:52 PM by Cristian Vasile Go to original post
• ###### 15. Re: shaded areas of 30 miles on a map

Thank you, Cristian

I think I got it.

Appreciate it.

Thank you,

Louise Prister

865-914-4546

• ###### 16. Re: Re: shaded areas of 30 miles on a map

Louise,

You can play a little bit with maps options and Marks, Color & Transparency to get a more good looking viz.

Regards,

Cristian

• ###### 17. Re: shaded areas of 30 miles on a map

Thank you so much…

Louise Prister

865-914-4546

• ###### 18. Re: shaded areas of 30 miles on a map

Hi Cristian,

This tool definitely doesn’t like me

Can you help, please.

I have two data sources in my worksheet: regular SQL from my DB with Lat and Lon, and a excl file with a list of degrees (from 1 to 360)

I didn’t create any relationship between these two data sources (and it might be a problem, though I don’t know how to connect them)

When I create a calculation using the formula below the tool produces an error  syntax error (maybe you are missing an operator.

DEGREES(ASIN(

)) )

Thank you,

Louise Prister

865-914-4546

• ###### 19. Re: shaded areas of 30 miles on a map

Louise,

My suggestion is to ask your DBA or db programmer to compute the lat/lon for each 360 points for all vendors premise and store them in a separate table. The formulas are in provided excel file, it's not a difficult task.

Then you should be able to query vendors' premise lat/lon including all current attributes (name, sales, profit, expenses, etc) and join/data blend on an unique key with new neighborhood locations and plot them on a map.

This approach means that heavy duty task of computing 7,000X360 = 2,520,000 points is done by db engine, and Tableau just display the data.

But I must say the map decorated with 2,5M points will look clutter, and i am afraid that managers will not understand your visualization.

Regards,

Cristian.

• ###### 20. Re: shaded areas of 30 miles on a map

Louise,

I shall ping Allan, maybe he have time to take a look and post fresh thoughts.

>ping -l 32 -w 300 -n16 Allan

Regards,

Cristian

• ###### 21. Re: shaded areas of 30 miles on a map

Hi Christian,

I've been following the thread with some interest.  All I would say is if the perimeters are the same, and the centroid is the same - i.e. the locations don't move - I think it might be easier constructing this as custom shapefiles.  But definately do a union/join (I suspect it is a left outer) on the tables.

Allan

• ###### 22. Re: shaded areas of 30 miles on a map

Is there a video on a shape file?

And if I do a join, what do I have to join with what?

I have a table with Lat and Lon, and  I thought I would be able to create 360 additional records dynamically, using the excl file, but it doesn’t work ttis way.

Thank you,

Louise Prister

865-914-4546

• ###### 23. Re: shaded areas of 30 miles on a map

Hi Louise,

For creating custom shapefiles, have a read here.

For the formulae in Excel, I think it will be a case of filling the formulae down.

Christian is right I think, the more pre-processing you do outside of Tableau the better performance you'll get.

Best Regards,

Allan

• ###### 24. Re: shaded areas of 30 miles on a map

Hello Allan,

Thank you for jumping on this cold water.

I remember that viz created by Tableau experts related to trochoids... Theta Analysis | Tableau Software

Now, i am wondering if such an approach could work in this case,  because Louise radius is constant and equal with 15miles; I choose gear ratio = 0 and the second parameter = 2 and i get a nice curve similar with a circle.

Regards,

Cristian.

• ###### 25. Re: shaded areas of 30 miles on a map

Hello Cristian,

Can we also show the vendor location point with the circle? I tried with dual axis. It's not allowing me to put vendor locations on the same map.

• ###### 26. Re: shaded areas of 30 miles on a map

Hello,

The vendor point aka the center of the circle should have the lat&long computed as for any other point and placed on the same excel or db table as all points.

1 2 Previous Next