2 Replies Latest reply on Jul 26, 2018 11:53 PM by Louis Koh

    Range Plot & Size of plot

    Louis Koh

      I am very new to Tableau and I have an requirement to a chart. I was wondering I can get some assistance in developing this.

      The Data table has the following columns :

      Date (in years)

      Names

      Country

      Industry

      Market Cap

      Rank

      P/E Ratio (includes Nan)

       

      I am trying to build a chart where :

      I can see the range of the P/E Ratio (Max, Min, Average) via a Range Plot / Gap chart across Year, Industry, Continent (via country).

      I have tried many options but i cant seem to put the max, min, average into a the same plot

      Also is it possible to automatically classify country into continents ?


      Secondly, I am trying to plot the changes in ranking of 4 companies across time. Similar to this https://en.wikipedia.org/wiki/Rafael_Nadal#/media/File:Singles-Ranking-Composite-History-Chart-RogerFederer%2BRafaelNadal%2BNovakDjokovic.png

      But with the size of the dots at every year corresponding to the size of the market cap

        • 1. Re: Range Plot & Size of plot
          kumar bharat

          Hi Louis,

          Can you share dummy data.

          BR,

          bharat

          • 2. Re: Range Plot & Size of plot
            Louis Koh

            For the part 1 : data

             

            So I hope to visually show the range of (max or 75 percentile, median/average, min or 25 percentile) for PE given country / year / industry / rank  (different sorts to show how it impacts the PE range)

             

             

            DateMarket CapShort NameRankPECountryIndustry
            1997160EG124UNITED STATESIndustrial
            1997130TC243UNITED STATESConsumer, Non-cyclical
            1997120I330BRAZILTechnology
            1997120CME419UNITED STATESEnergy
            1997120TN510JAPANCommunications
            1999440RH135GERMANYFinancial
            1999350M271UNITED STATESTechnology
            1999330EG338UNITED STATESIndustrial
            1999200IC436UNITED STATESTechnology
            1999180WN545UNITED STATESConsumer, Cyclical
            2001490I140BRAZILTechnology
            2001480EG239UNITED STATESIndustrial
            2001300CME319UNITED STATESEnergy
            2001290IP433UNITED STATESConsumer, Non-cyclical
            2001280SC568UNITED STATESCommunications

                                                                                                                                                                                                                                                

            Ranking : AMarket Cap ARanking : BMarket Cap B
            1997125010
            1998183010205010
            19997601027020
            20003502023030
            200110401095010
            200262010106010
            20037801057010
            20047101026030
            20052403036020
            20061007038020
            20071108059020
            20084018029040
            2009608025030
            20102019011060
            201133008090
            201233808080
            2013151060120
            2014151030190
            Mar-15165050150
            Jun-15159010320
            Sep-15162010360
            Dec-15487010570

             

            For part 2

             

            So I hope to show the ranking changes across time and towards the last year how it change in each quarter and using the size of the marker to show the market cap

             

            Ranking : AMarket Cap ARanking : BMarket Cap B
            1997125010
            1998183010205010
            19997601027020
            20003502023030
            200110401095010
            200262010106010
            20037801057010
            20047101026030
            20052403036020
            20061007038020
            20071108059020
            20084018029040
            2009608025030
            20102019011060
            201133008090
            201233808080
            2013151060120
            2014151030190
            Mar-15165050150
            Jun-15159010320
            Sep-1556208360
            Dec-15487010570