2 Replies Latest reply on Aug 23, 2017 6:35 AM by Jeffrey Wong

    Can't get Y axis origin set to 0

    Andy Harsin

      Tableau Public

       

      Link above.

       

      I am making a plot in Tableau Public with date on the X axis and event occurrence on the Y axis. The range for Y is large, 1 to several thousand, so I am using a log scale for the Y axis. My problem is that for instances

      where Y = 1, the symbols are cut in half by the X axis because I cannot get the Y origin to be equal to 0 (or <1, for that matter). I understand that log cannot equal 0, but there must be some way for the entire symbol to be visible when Y = 1.

       

      Thanks for any help

        • 1. Re: Can't get Y axis origin set to 0
          Patrick A Van Der Hyde

          Andy,

           

          This is a tough one. I used a tecnique I found by Jonathan Drummey in this post - Logarithmic Scale issue: Bar chart is not appearing in "X" axis for Value 1  to change the calculation for one of the axis to a Log value on the Rows shelf.  The log values are better to hide on the axis and instead use the tooltip or show text on the viz to display this info.

           

          I attached a 10.2 version of this viz  updated here as well if that helps.

           

           

           

          I hope this helps,

           

          Patrick

           

          If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution.  Thank you.

          • 2. Re: Can't get Y axis origin set to 0
            Jeffrey Wong

            I have also faced the same problem where value of 1 does not show on a logarithmic scale axis.

            To overcome this I used a dirty hack of adding an offset of 0.1 - 0.4 where values 1 via means of creating a calculated field.

             

            For aggregated / calculated values like Count, Sum or Average, I created a custom calculated field.

            Example of formula used in calculated field: COUNT( [Id] ) + 0.4

            The additional value of 0.4 helps the bar to be shown on the bar chart. (offset of 0.4 makes the bar looks more prominent)

             

            Also do not forget to change the number format for the calculated field to have zero decimal places.

            By doing this, any value between 0.1 - 0.4 will be rounded down so in terms of presentation of the Mark Label on the bar chart it will show the same value as if the offset was never applied.

             

            This is not perfect but a workaround. Not sure if this will suit your need but I hope it helps.