-
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
-
-
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(
SIN(RADIANS())*COS(50/6371) +
COS(RADIANS())*SIN(50/6371) *
COS(RADIANS(ATTR(.[Degree])) )
)) )
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.
