Could you post a sample worksheet or mock-up drawing with what it is you are looking for? I'm not quite following what you are looking for...
I have a map like the below with the # of orders plotted on the map. You can see they are in pockets. I would like someway of putting our brick and mortar store locations on the map - i was thinking in the form of some type of symbol or maybe changing the color of the map.
Does that make sense?
Are the brick and mortar locations contained in the same data source or are they somewhere else?
Do you have a twbx you could attached with where you're at so far and any example data that might need to be added?
The brick and mortar locations would be contained in a separate data source, it'd essentially just be a list.
I can not share the twbx or anything beyond the screen shot unfortunately. Apologies if that makes it a little more challanging.
If they exist in the same source type i.e. the same database as different tables you could perform a union on the two tables with an added column for "LocationType". The top select statement would have
"Data" as LocationType added as a field
and the second select statement of the union would have
"Store" as LocationType
So you'd have a new dimension in your connection called LocationType that you could put on the shapes mark type.
Data shapes could be circles like you currently have and your B&M's could be a picture of anything else you like.
Of course the schemas will have to be made to match for a successful UNION so you'll have to account for missing fields in either table with zeros or a default value of your choosing within your select statements.
Let me know if that helps
If they're on a map they need to be in the same data or at least blended before you go down this path. That's where the union comes in to play. You can manually append them to your data as well if that's easier for you. Blending will most likely not work for what you're trying at it's current state. Is the image below somewhat like what you're trying to do? Lightbulb representing a store. Circles representing whatever else you had showing such as a measure for color or size of data points that aren't stores.
What you described with the green dots and light bulb is what i am looking for. Blending the data doesnt appear to be working for me at the moment.
This is now in the Tableau support queue. I will let you know what they come up with
After a call with Tableau support I have the solution - just follow the below steps. This assumes you have an excel file with your stores
1. Drag a second copy of "Latitude (generated)" to the Rows Shelf (from original source)
2. Drag "Zip Postal Codes" from the Dimensions Pane to the Detail Shelf (from original source)
3. Change the Mark Type to "Shape"
4. Create a new data connection to the Excel file containing Store Locations (Connect to Data > Excel)
5. Create a relationship between "ZIP Postal Codes" (source 1) and "Store Zip" (source 2) (Data > Edit Relationships)
6. Create a new Calculated Field with the following text:
IF NOT ISNULL(LOOKUP(ATTR([Store Locations].[Store Zip]),0)) THEN "Store" ELSE "Not Store" END
*[store locations] = data source containing the store locations
7. Drag the Calculated Field from Step 4 (I named mine "Has Store") to the Shape Shelf
8. Ensure that the Store Image is Imported as a Custom Shape: http://onlinehelp.tableausoftware.com/current/pro/online/en-us/help.htm#viewparts_marks_markproperties_shape.html
9. Choose the custom Store Image to apply to the "Store" member of "Has Store"
10. Right-click on the "Not Store" member on the "AGG(Has Store)" Shape Legend and select "Hide"
11. Right click on the second latitude you created in step 1 and select 'Dual Axis'
That should cover it, if you have any issues with this please let me know.
With the blending solution, make sure to keep in mind that that if you ever have a store with a Zip Code where that Zip Code doesn't exist in your primary dataset it won't show up on your map. I'm assuming this isn't the case with your data.
That is what i thought as well but the tableau support person showed me that doing it this way they always all show up. Even when i filter for specific zip codes all the store locations show up.
1 of 1 people found this helpful
Those tech support folks are pretty good, aren't they? This particular bit of cleverness is probably a Wilson Po creation I recently found via Russell Christopher (aka Tableau Love). Glad it worked for you.
But Aaron's warning is correct. If your store location ZIP code is not in both data connections the store will not show up, because there is nothing to blend on; no linking ZIP code. You'll end up with a Null:
The LOOKUP() trick will not change this.
The other thing to be aware of is your store locations will NOT be the actual store location. It will be the center of the zip code. So if your store is out on the edge of the ZIP code your client might complain (mine do) that that isn't where their store is. If that is the case for you then you might find this helpful:
To use this you'll need to set up your data a bit differently. I'll be happy to show you how, if you're interested.
In hind sight and after playing around, you both are right. Apologies.
Fortunately all me Zip Codes will be present for this so that shouldn't be an issue but something i'll definitely keep in mind for the future.
I will note your 'where the store sits on the map' piece, i am sure this will come up eventually for my clients.
Thank you for all the thoughtful responses.