2 Replies Latest reply on Sep 23, 2016 12:06 PM by Jeeson Thekkekara

    Market Share chart - Two bargraphs on each axis

    Jeeson Thekkekara

      Hi,

      Can anyone help me in creating below chart in tableau:

      The dataset is given below:

             

      Slab(A)Slab_Text(B)NotCust(C)TotalCust(D)%ofCustomersInGlobalMix(E)CustomerMix(%)(F)GlobalMix(%)(G)
      1< 1,000,000340318.424.845.4
      21,000,000 to 10,000,0002476621.152.838.3
      310,000,000 to 25,000,000621115.18.88.9
      425,000,000 to 50,000,00022929.07.23.8
      5> 50,000,00022826.76.43.7

       

       

      % of customer in Global Mix is calculated as "=D2/(D2+C2)*100"

      Customer Mix (%) is calculated as "=D2/SUM($D$2:$D$6)*100"

      Global Mix (%) is calculated as "=(C2+D2)/SUM($C$2:$D$6)*100"

       

      I am attaching the dataset for your perusal.

      How to Create a 100% Stacked Bar with Absolute Values (Tableau Public)

      Amy SchneiderBarry Plum

      The specified item was not found.The specified item was not found.Erin Easter

       

      Forums