2 Replies Latest reply on Nov 20, 2018 8:30 AM by Jonathan Drummey

    Time Series and Axis range


      Dear community,0/


      I have a dataset with different measures per employee over the years. Each customer has a flag 0/1 (1=italian employees, 0=worldwide employees).
      The one's are 30 while the 0's are 150


      I'm bulding a dashboard that compares the employees (0 vs 1) average productivity over the years... I have a problem with the axis range. The blue sample is smaller in number and therefore has a low average productivity compared to orange. In this way, the trend of the blue is not legible (the blue line is not flat, it simply has a lower avg value, around 100K). How can I represent this line graph  in such a way that the two trends are legible?




      The graph will show the annual % difference (compared to the previous year).


      How can I edit the axis?

      Thank you very much for helping



        • 1. Re: Time Series and Axis range
          Yuriy Fal

          Hi Giovanna,


          There are ways to compare trends / changes

          among time series of different magnitudes.


          The transformations could be as follows:


          1) Use a Logarithmic Scale .In Tableau it is a property of the Axis.


          2) Calculate a Percent Difference as compare to the first Mark.

          In Tableau it could be done as a Quick Table Calculation --> Percent Difference.

          Compute using --> Table across (or better the [Date] pill).   Relative to --> First


          3) Add another discrete (blue) pill on Rows (a Dimension or Measure Names)

          to draw each time series in its own Pane, then use the option on the Axis:

          Independent axis ranges for each row or column.


          The latter is my favourite.




          • 2. Re: Time Series and Axis range
            Jonathan Drummey

            One more - use a dual axis.