5 Replies Latest reply on Apr 12, 2016 1:22 AM by Steve Taylor

    How to synchronise the axis?

    Dyna Lee

      Hello guys

       

      I would like to have the value of the 2 axes synchronised [A]. Could you please tell me how to do that? The Option in Tableau can't be Chosen [B]

       

      Thanks a lot and best regards

       

      dyna

        • 1. Re: How to synchronise the axis?
          Steve Taylor

          Hi Dyna

           

          Sometimes you can't synchronise the axes because the data type of the two measures is different. Can you check if they're both integer or float? if they're different you can create a calculated field to convert one measure so they do match.

           

          That's the first thing I check.

           

          Thanks

           

          Steve

          • 2. Re: How to synchronise the axis?
            Rohan Malusare

            Hi Dyna,

            For synchronize the axes the data type need to be in same format, if your data format is same you can follow the below steps:-

             

            1.png

             

            2.png

             

             

            try this.I hope this will solve your problem.

             

            Regards,

            Rohan Malusare.

            • 3. Re: How to synchronise the axis?
              Dyna Lee

              Dear Steve

               

              I have the measure DELAY

               

              DELAY

              if [communicated delivery date] <> [real delivery date]

              then 1

              else 0

              end

               

               

              The bar Chart uses the measure DELAY > SUM(DELAY)

               

              Then I copied the DELAY measure > AGG(DELAY COPY) > I Need the average value for the delay.

               

              But somehow the average value is completely wrong. Which calculation should I use to receive the correct average?

               

              Best regards

              • 4. Re: How to synchronise the axis?
                Steve Taylor

                Hi Dyna,

                 

                The original question was about synchronising axes, if those are your two calculated fields I'd wrap the calculations with the INT(<your calc here>) function so that both measures are the same data format, then you should be able to synchronise the axes.

                 

                It's difficult to say what average is correct without being able to see your workbook or know what it is you're trying to show. Is there a way you can anonymise your data or replicate the situation with superstore data and upload a twbx file here so I can try and help?

                 

                Thanks

                Steve

                • 5. Re: How to synchronise the axis?
                  Steve Taylor

                  Hi Dyna,

                   

                  Could you create an extract of your datasource (right click on datasource and select Extract Data) before saving as a twbx please? I can't access the live connection you have in the workbook because I'm not connected to your Oracle server so can't create any calculated fields.

                   

                  Thanks

                   

                  Steve