1 of 1 people found this helpful
If the data doesn't have any relationship between the two, then I do not believe this to be possible. The best option would be to create two separate maps and place them on a dashboard together.
Having done this, is there a way to overlay the two sheets on the dashboard, or to export as a usable layer in other mapping software?
Maybe some custom SQL to pull from both? Are they at least both from SQL, or both from Access, or...
Working with csv files at the moment, but happy to put them into access if there is a solution....
I have thought of combining the data into one sheet using a new category for 'vehicle' 'depot' and 'site'
But then I need to:
-bin vehicle data into several categories based on latency field
-display several sub categories of depots, and
-add a 20km radius around each site (this is a nightmare in itself...currently done with mapinfo)
Would a single sheet approach make sense / be workable?
CSVs are fine - could pull from them in a custom SQL solution. The one sheet method would work fine as well - either define your extra info, or use groupings/calcs.
For the 20km radius, see my solution to it here: http://community.tableau.com/thread/117325#177737
I have combined it to one sheet but cannot get the display I want (sorry, very new at tableau!)
I have attached a sample in my original post....
I desparately need help to get the desired display of:
vehicles - colored with a traffic light based on the delays column
depots - different symbol for the different types of depot
deliverys - will have a 20km radius in the final product (but I will figure this out myself) - for now another symbol
I cant find a similar scenario in the examples - perhaps it is all to hard to do on one sheet?
First I need to get my head around how to plot it all with a small sample...then I will tackle the SQL/csv with all my records
I didnt know about the multiple fields trick...
Note the dual axis latitude as well - this gives us another layer to dump pills on
I noticed that you hid the NA values when mapping points on the depot field.
Using my full data set I cant find the option to hide the NA values. I tried searching the help and forums but couldnt figure out how to do this. I can use the filter option but that makes all the other data disapear - how do you simply hide the NA or null values?
After that I need to tackle the problem of adding another layer of polygons around some points
I think I right clicked on the legend entry.