Create A Map with Multiple Layers in Tableau
In this video you'll learn how to create a map with multiple layers in #Tableau using Tableau's included superstore data set.
We'll start by building a filled map that represents the profit by state.
We'll layer on top of this map a pie chart that breaks down Sales by Category.
As a bonus tip we'll touch upon the FIXED Level of Detail (LOD) expression in order to calculate a percentage of sales by state and category for the pie chart.
Join this channel to get access to perks:
/ @anthonysmoak
★☆★ FOLLOW ME BELOW: ★☆★
bit.ly/m/anthonysmoak
☕☕ If my channel has helped you, consider buying me a coffee! Thanks & Cheers! ☕☕
www.buymeacoffee.com/anthonys...
★☆★ Support this Channel: ★☆★
👕 Merch ► shop.spreadshirt.com/AnthonySmoak
★☆★ VIEW THE BLOG POST: ★☆★
anthonysmoak.com/2017/07/03/c...
#Tableau #datavisualization #data #analytics #data #dataanalyst #education #onlinelearning
Пікірлер: 84
My first video to top 100K views; thank you all for watching!
@aaronwu1564
4 жыл бұрын
when I google "Having multiple colors in a filled map", this useful video shows up ;)
Thanks for sharing Anthony, very clear a good example showing how to do a map in Tableau...
WoW. no words.. lot of information in this video. Thank you so much.
so so helpful and straight forward, thank you!
This is just amazing! Thanks Anthony :)
Thank you so much! Solved my problem in less than a minute.
thank you Anthony, learnt a lot! you are amazing teacher.
This was really helpful. Many thanks!
Thanks a lot..Its really helpful to learn the filled and symbol map.
This helped me do a presentation of Nissan models buyer keywords searches by state - thanks!
Helpful and nice video. Thank you!
Hey Anthony, thank you so much for the video. Can you please tell me if there is a way to create state abbreviations from the existing state column?
You are so great men, thank you so much for your video!!!
I like your video. very straightforward and get things done! Subscribed and shared with friends!
@AnthonySmoak
3 жыл бұрын
I appreciate this! Thank you!
I vote Anthony Smoak 2020. Thank you for this, fixing problems before I even knew I had them!
@AnthonySmoak
3 жыл бұрын
Thanks for the vote!
I love your videos!!! Thank you for sharing!
@AnthonySmoak
3 жыл бұрын
Thank you so much for the comment!
Thank you Anthony ! This is really useful :) Cheers !
@AnthonySmoak
4 жыл бұрын
Thank you Riaz!
This is an amazing video! Thank you!
@AnthonySmoak
3 жыл бұрын
Thank you for the great comment!
Is there any way to layer multiple maps (ie: more than two)?
Great video 👍
This video has helped me. Thank you for sharing
@AnthonySmoak
4 ай бұрын
Fantastic, thank you for sharing this comment!
Great video! Is there a way to not show the circle for a certain state? Let's say in Montana there is no sales, and I want to not show the circle there, instead of showing a sales of $0. Thank you!
amazing showing
Hello, If I wanted (based on a parameter) to show or not show (filter) the "pies" layer. How would you go about that? Thank you!!!
YOU ARE A TABLEAU GOD. DUAL AXIS FTW!!!
Thank you so much. I get it in 5 minutes.
Thank you.. so easy to follow
@AnthonySmoak
6 жыл бұрын
Glad you found it useful Lynn!
@LanP92804
6 жыл бұрын
I am a new beginner and i've been looking for several tutorial video, so far this one is the most easy one for me... thank you. Waiting for more from your video tableau tutorial.
Fantastic! Thanks so much. P.S. I would vote for you:)
@AnthonySmoak
4 жыл бұрын
I appreciate your support!
thanks Anthony
Vote Anthony smoak in 2020 amazing tutorial
@AnthonySmoak
3 жыл бұрын
Thank you! Sounds like I can count on your support!
Making Dual Axis made may day, thx so much
@AnthonySmoak
3 жыл бұрын
Fantastic, glad to hear it!
When I drag my second measure over the circle it changes the value of the background measure of the lower map.
Hi, in multiple layer view, I actually need a feature like if we click on suppose one of the sites in the US then other sites who are linked with that particular site in the database also highlighted on the map and other remaining would automatically view in lighter shade in the background. How can I implement this feature? Please advise.
You are a God!
Love your energy lol
@AnthonySmoak
2 жыл бұрын
Thanks, I try!
Anthony I am trying to make it to where I can go to the Day, then filter to the action of that day. So basically I want a two layer map (I think). AM i heading in the right direction here?
So how do I show the highest measure on a map using filters?
@Anthony B. Smoak I am new to tableau. Is there any possibility to connect it with web ? Or To covert this tableau projcet file to html ?
Is this consider drilldown?
thanks! need this! do you know if i have specific places with latitude and longitude how could it be, since it will be two different Measures for each, the state at the back, and the sites at the front
Hello Anthony - great video - is it possible to add an object (in relation with the value info) that would be bigger if the value is high ? if yes, how ?
@AnthonySmoak
Жыл бұрын
I'm not sure I understand fully. You can throw this visual on a dashboard that holds an additional chart if needed.
hi , thank you for information it's really usful for me . i want ask you if you know how wa can export data from twitter by location
I noticed you didn't label the the individual slices of the pie charts. I tired and couldn't figure it out. Is it not possible
is it possible to flip back and forth between two maps of varying year with different color gradients?
@AnthonySmoak
2 жыл бұрын
I would create two different map worksheets, place them on a dashboard and then use a parameter technique to show/hide the different worksheets as needed.
Can you recreate this video to include Hawaii and Alaska? Please and thank you.
Can you please explain, how did you actually get the percentage value? The formula your are showing, is providing Sales by State. How are you getting the percent value out there? Correct me if I am wrong. Thanks in advance.
@saikiranvemula
6 жыл бұрын
Hi Sales can change into percentage by right click and change to percentage, sum etc,
@AnthonySmoak
6 жыл бұрын
Use the formula presented at 5:55 to create a calculated field
@lakshmisaijahnaviswamy7699
4 жыл бұрын
right click on pct sales > default properties > number format > percentage should do
@anshulaggarwal9601
4 жыл бұрын
Even I am facing the same issue. My values are not converted into percentage and no percentage sign is enabling
@anshulaggarwal9601
4 жыл бұрын
@@lakshmisaijahnaviswamy7699 Thanks for such valuable point
this is great, assuming your data is structured to have a category field....but how can one add a pie on a map if the two categories you have are in two separate columns? A State Name B Category 1 C Category 2?
@Orholam5
4 жыл бұрын
nevermind, I discovered you can select two columns in tableau and pivot on them!
Hi, Thanks for the video but I have one doubt here in the video time is 1.51 to 2.0 min whatever you will do, is it possible to do in 2019.2 version tableau??? I tried but it is not working, can you please help me for the same ASAP, I got stuck in between the work...
@AnthonySmoak
10 ай бұрын
Make sure you are holding down control while dragging the Rows pill. This feature still works in Tableau as it is a fundamental part of creating dual axis charts.
hi I want to follow the steps that you have done in this video. Can I have the original Excel file?
@AnthonySmoak
Жыл бұрын
This is performed on the dataset that Tableau distributes with the desktop edition. Do a google search for Sample Superstore dataset, and you should find a copy (it may not be this exact version, but it should work for the lesson).
may i know why i am not able to drag and duplicate the latitude?
@AnthonySmoak
2 жыл бұрын
Hold down the CTRL button if you are using a PC.
Can we layer more than one?
@AnthonySmoak
4 жыл бұрын
Not that I am aware but Zen Masters are always pushing the envelope. Try a quick check of the forums.
i dont see an example of the Data source used for this video?
@AnthonySmoak
5 жыл бұрын
It's the standard Tableau Superstore data set.
@nabilbeitinjaneh
3 жыл бұрын
@@AnthonySmoak The Superstore dataset gets updated every now and then... Have not checked recently. Best to create a Tableau Public twbx...
Would be helpful if you showed the data structure up front
I have no clue how to make the sales by state column
1:55 Anthony says hit control to duplicate, on my MacBook machine I had to hold command key
@AnthonySmoak
2 жыл бұрын
Good callout for Mac users!
{Fixed [State],[Category]: Sum([Sales])}/ {FIXED [State] : Sum([Sales])} thanks