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

  • @AnthonySmoak
    @AnthonySmoak4 жыл бұрын

    My first video to top 100K views; thank you all for watching!

  • @aaronwu1564

    @aaronwu1564

    4 жыл бұрын

    when I google "Having multiple colors in a filled map", this useful video shows up ;)

  • @clevejones9411
    @clevejones94116 жыл бұрын

    Thanks for sharing Anthony, very clear a good example showing how to do a map in Tableau...

  • @DeepakBusanagari
    @DeepakBusanagari6 жыл бұрын

    WoW. no words.. lot of information in this video. Thank you so much.

  • @aaronwu1564
    @aaronwu15644 жыл бұрын

    so so helpful and straight forward, thank you!

  • @ridhimatalwar3691
    @ridhimatalwar36915 жыл бұрын

    This is just amazing! Thanks Anthony :)

  • @ritika.upadhyay
    @ritika.upadhyay5 жыл бұрын

    Thank you so much! Solved my problem in less than a minute.

  • @michafabich4372
    @michafabich43723 жыл бұрын

    thank you Anthony, learnt a lot! you are amazing teacher.

  • @olayinkaaremu2945
    @olayinkaaremu29452 жыл бұрын

    This was really helpful. Many thanks!

  • @nagendrakm7381
    @nagendrakm73815 жыл бұрын

    Thanks a lot..Its really helpful to learn the filled and symbol map.

  • @thinknewideas4131
    @thinknewideas41315 жыл бұрын

    This helped me do a presentation of Nissan models buyer keywords searches by state - thanks!

  • @maikel72
    @maikel725 жыл бұрын

    Helpful and nice video. Thank you!

  • @nitikasharma8269
    @nitikasharma82692 жыл бұрын

    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?

  • @danielbaena4691
    @danielbaena46916 жыл бұрын

    You are so great men, thank you so much for your video!!!

  • @tinetine205
    @tinetine2053 жыл бұрын

    I like your video. very straightforward and get things done! Subscribed and shared with friends!

  • @AnthonySmoak

    @AnthonySmoak

    3 жыл бұрын

    I appreciate this! Thank you!

  • @frankystephenson8587
    @frankystephenson85873 жыл бұрын

    I vote Anthony Smoak 2020. Thank you for this, fixing problems before I even knew I had them!

  • @AnthonySmoak

    @AnthonySmoak

    3 жыл бұрын

    Thanks for the vote!

  • @yolindaburns3447
    @yolindaburns34473 жыл бұрын

    I love your videos!!! Thank you for sharing!

  • @AnthonySmoak

    @AnthonySmoak

    3 жыл бұрын

    Thank you so much for the comment!

  • @riazahmedshaik
    @riazahmedshaik4 жыл бұрын

    Thank you Anthony ! This is really useful :) Cheers !

  • @AnthonySmoak

    @AnthonySmoak

    4 жыл бұрын

    Thank you Riaz!

  • @josephdarmiento3622
    @josephdarmiento36223 жыл бұрын

    This is an amazing video! Thank you!

  • @AnthonySmoak

    @AnthonySmoak

    3 жыл бұрын

    Thank you for the great comment!

  • @simoneveringham8018
    @simoneveringham80186 жыл бұрын

    Is there any way to layer multiple maps (ie: more than two)?

  • @rajeshtukdeo
    @rajeshtukdeo6 жыл бұрын

    Great video 👍

  • @polycarpnalela6951
    @polycarpnalela69514 ай бұрын

    This video has helped me. Thank you for sharing

  • @AnthonySmoak

    @AnthonySmoak

    4 ай бұрын

    Fantastic, thank you for sharing this comment!

  • @statisticalgp
    @statisticalgp6 жыл бұрын

    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!

  • @xudong5269
    @xudong52694 жыл бұрын

    amazing showing

  • @abrahamolivero2955
    @abrahamolivero29553 жыл бұрын

    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!!!

  • @jjgravante
    @jjgravante3 жыл бұрын

    YOU ARE A TABLEAU GOD. DUAL AXIS FTW!!!

  • @tokai7548
    @tokai75482 жыл бұрын

    Thank you so much. I get it in 5 minutes.

  • @LanP92804
    @LanP928046 жыл бұрын

    Thank you.. so easy to follow

  • @AnthonySmoak

    @AnthonySmoak

    6 жыл бұрын

    Glad you found it useful Lynn!

  • @LanP92804

    @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.

  • @ksenianewton4893
    @ksenianewton48934 жыл бұрын

    Fantastic! Thanks so much. P.S. I would vote for you:)

  • @AnthonySmoak

    @AnthonySmoak

    4 жыл бұрын

    I appreciate your support!

  • @rajsamant1
    @rajsamant14 жыл бұрын

    thanks Anthony

  • @tanshmay
    @tanshmay3 жыл бұрын

    Vote Anthony smoak in 2020 amazing tutorial

  • @AnthonySmoak

    @AnthonySmoak

    3 жыл бұрын

    Thank you! Sounds like I can count on your support!

  • @qarah3757
    @qarah37573 жыл бұрын

    Making Dual Axis made may day, thx so much

  • @AnthonySmoak

    @AnthonySmoak

    3 жыл бұрын

    Fantastic, glad to hear it!

  • @michaelsmith1076
    @michaelsmith10762 жыл бұрын

    When I drag my second measure over the circle it changes the value of the background measure of the lower map.

  • @rajatgupta7103
    @rajatgupta71033 жыл бұрын

    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.

  • @ansonkho1673
    @ansonkho16735 жыл бұрын

    You are a God!

  • @isaaksiebenga7663
    @isaaksiebenga76632 жыл бұрын

    Love your energy lol

  • @AnthonySmoak

    @AnthonySmoak

    2 жыл бұрын

    Thanks, I try!

  • @Turbotoastcomics
    @Turbotoastcomics2 жыл бұрын

    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?

  • @KAPPIEY
    @KAPPIEY4 жыл бұрын

    So how do I show the highest measure on a map using filters?

  • @03026899677
    @030268996774 жыл бұрын

    @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 ?

  • @ansonkho1673
    @ansonkho16735 жыл бұрын

    Is this consider drilldown?

  • @rolandoamirmirabalhinojosa7091
    @rolandoamirmirabalhinojosa70915 жыл бұрын

    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

  • @genevieve3676
    @genevieve3676 Жыл бұрын

    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

    @AnthonySmoak

    Жыл бұрын

    I'm not sure I understand fully. You can throw this visual on a dashboard that holds an additional chart if needed.

  • @zainabalfaqeer8577
    @zainabalfaqeer85773 жыл бұрын

    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

  • @mtsmitty66
    @mtsmitty664 жыл бұрын

    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

  • @thebbqprince
    @thebbqprince2 жыл бұрын

    is it possible to flip back and forth between two maps of varying year with different color gradients?

  • @AnthonySmoak

    @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.

  • @dwilliamschappell836
    @dwilliamschappell8363 жыл бұрын

    Can you recreate this video to include Hawaii and Alaska? Please and thank you.

  • @shangruffraina4750
    @shangruffraina47506 жыл бұрын

    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

    @saikiranvemula

    6 жыл бұрын

    Hi Sales can change into percentage by right click and change to percentage, sum etc,

  • @AnthonySmoak

    @AnthonySmoak

    6 жыл бұрын

    Use the formula presented at 5:55 to create a calculated field

  • @lakshmisaijahnaviswamy7699

    @lakshmisaijahnaviswamy7699

    4 жыл бұрын

    right click on pct sales > default properties > number format > percentage should do

  • @anshulaggarwal9601

    @anshulaggarwal9601

    4 жыл бұрын

    Even I am facing the same issue. My values are not converted into percentage and no percentage sign is enabling

  • @anshulaggarwal9601

    @anshulaggarwal9601

    4 жыл бұрын

    @@lakshmisaijahnaviswamy7699 Thanks for such valuable point

  • @Orholam5
    @Orholam54 жыл бұрын

    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

    @Orholam5

    4 жыл бұрын

    nevermind, I discovered you can select two columns in tableau and pivot on them!

  • @bharathnbgowda7923
    @bharathnbgowda792310 ай бұрын

    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

    @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.

  • @afshinazizi659
    @afshinazizi659 Жыл бұрын

    hi I want to follow the steps that you have done in this video. Can I have the original Excel file?

  • @AnthonySmoak

    @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).

  • @user-jk9kx5kb9s
    @user-jk9kx5kb9s2 жыл бұрын

    may i know why i am not able to drag and duplicate the latitude?

  • @AnthonySmoak

    @AnthonySmoak

    2 жыл бұрын

    Hold down the CTRL button if you are using a PC.

  • @leedixon9862
    @leedixon98624 жыл бұрын

    Can we layer more than one?

  • @AnthonySmoak

    @AnthonySmoak

    4 жыл бұрын

    Not that I am aware but Zen Masters are always pushing the envelope. Try a quick check of the forums.

  • @joshbarrett1093
    @joshbarrett10935 жыл бұрын

    i dont see an example of the Data source used for this video?

  • @AnthonySmoak

    @AnthonySmoak

    5 жыл бұрын

    It's the standard Tableau Superstore data set.

  • @nabilbeitinjaneh

    @nabilbeitinjaneh

    3 жыл бұрын

    @@AnthonySmoak The Superstore dataset gets updated every now and then... Have not checked recently. Best to create a Tableau Public twbx...

  • @ryanjohnson8313
    @ryanjohnson83135 жыл бұрын

    Would be helpful if you showed the data structure up front

  • @jankozak2984
    @jankozak29843 ай бұрын

    I have no clue how to make the sales by state column

  • @dr_frankenmiller2607
    @dr_frankenmiller26072 жыл бұрын

    1:55 Anthony says hit control to duplicate, on my MacBook machine I had to hold command key

  • @AnthonySmoak

    @AnthonySmoak

    2 жыл бұрын

    Good callout for Mac users!

  • @user-pv7gs1mw3h
    @user-pv7gs1mw3h Жыл бұрын

    {Fixed [State],[Category]: Sum([Sales])}/ {FIXED [State] : Sum([Sales])} thanks

Келесі