2 Replies Latest reply on Jun 7, 2018 6:52 AM by Divyay Gupta

    3 measures onto one graph

    Divyay Gupta

      Hello Tableau Community,

       

      I am trying to replicate this graph in Tableau. It has three measures (Bar, Circle, and Benchmark) and one dimension. I tries to use Benchmark (Overall in this case) as Reference Line but could not implement circles and bars. Does anyone know how to do this?

       

        • 1. Re: 3 measures onto one graph
          Mavis Liu

          HI Divyay,

           

          Is this what you're looking for?

           

          2018-06-07_14h29_48.png

           

          You can create a dual axis chart and then add in reference lines. Attached a workbook so that you can replicate, but here are also the steps:

           

          1) Create your first bar chart and then add in your second measure by dragging it into the shelf right next to the existing measure:

           

          2018-06-07_14h32_06.png

           

          2) Right click on the second pill and select dual axis:

           

          2018-06-07_14h32_32.png

           

          3) Right click on one of the axis and synchronise them:

           

          2018-06-07_14h33_08.png

           

          4) You should then have 3 marks card, one for all, and one for each of the measures. For the measure marks card, change one of the marks type to be bar and the other circle:

           

          2018-06-07_14h34_43.png

           

          5) Finally drag your final measure into details on the ALL marks card and then go to the analytics tab and add in the reference line:

           

          2018-06-07_14h35_39.png

           

          2018-06-07_14h36_00.png

           

          Thanks,

           

          Mavis

          • 2. Re: 3 measures onto one graph
            Divyay Gupta

            Hi Mavis,

             

            It really helped! Thanks so much for sharing it.

             

            Thanks,

            Divyay