6 Replies Latest reply on Jun 14, 2018 11:10 AM by Mavis Liu

    Shapes as Bars

    Nitin Paighowal

      Hello everyone,

       

      I am trying to create something like this where each bar is represented by some shape and the size corresponds to the total value of that bar.

       

       

      I tried to implement the same in Tableau however base of each shape starts from middle not from zero

       

      Any suggestions?

      Thanks,

      Nitin

        • 1. Re: Shapes as Bars
          Mavis Liu

          Hi Nitin,

           

          So your shapes start at zero, because you have 0.0 in the rows.

          To create this view:

           

          2018-06-14_17h40_49.png

           

          Create a bar chart by bringing sales into rows, then bring ANOTHER instance of sales in rows so that you have two side by side. Right click on the second sales pill and select dual axis:

           

          2018-06-14_17h39_42.png

           

          Right click on the secondary axis and select synchronise axis:

           

          2018-06-14_17h40_03.png

           

          Then change ONE of the marks type to bar, and the other to shape. For the shape assign an up arrow.

           

          2018-06-14_17h42_19.png

           

          Then make the size of your bar chart smaller, and your shapes bigger. You can either resize by clicking on size in the marks card, or you can drag sum sales into the size:

           

          2018-06-14_17h45_27.png

           

          Personally I don't think sum of sales needs to be in size because the height of the arrows shows the sum of sales already.

           

          Thanks, please see attached workbook for more information.

          Mavis

          • 2. Re: Shapes as Bars
            suman kumar

            Hi

             

            download the picture which you want to use instead of bar

            now go into document file of your system

            Documents-->My Tableau Repository-->Shapes-->Create a file and give any name and put your image inside of that folder.

             

            Now go into Tableau and select Marks

            Screen Shot 2018-06-14 at 10.11.33 PM.png

            Select shape like above in the picture.. then

            click on shape--> more shape and then click on "reload shape"

            Screen Shot 2018-06-14 at 10.12.48 PM.png

             

            Now once you click on default arrow which you can see in just above image then you'll be able to see your image there.

             

            Now create any view and select shape instead of bar in marks card. and select shape by clicking on more shape.

             

             

            Thanks

            Suman

            • 3. Re: Shapes as Bars
              Nitin Paighowal

              Hello Mavis,

               

              I dont want to create Arrow headed bars. I want to create any random shape as bar like this-

              With Tableau, all shapes are positoned at their aggregate value which I dont want. I want them to start from zero

              1 of 1 people found this helpful
              • 4. Re: Shapes as Bars
                Mavis Liu

                Hi Nitin,

                 

                Then please type in min(1) as an adhoc calculation in rows and then bring your sum(sales) into size in the marks card. Right click on the axis and then fix it to start from 1 and end at 2:

                 

                2018-06-14_18h05_39.png

                 

                2018-06-14_18h05_24.png

                 

                2018-06-14_18h05_29.png

                 

                You'll then get this:

                 

                2018-06-14_18h06_21.png

                 

                You can edit the axis if you want the shapes even bigger.

                 

                Please see attached workbook.

                 

                Thanks,

                 

                Mavis

                2 of 2 people found this helpful
                • 5. Re: Shapes as Bars
                  Nitin Paighowal

                  Thanks Mavis,

                   

                  It doesn't work for other shapes:

                   

                  1 of 1 people found this helpful
                  • 6. Re: Shapes as Bars
                    Mavis Liu

                    Hi Nitin,

                     

                    Right click on the axis and edit the range, maybe you should start at -0.5 or something.

                     

                    Thanks,

                     

                    Mavis