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

    Time Series and Axis range

    giovanna.devincenzo.65

      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?

      Cattura.PNG

       

       

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

       

      How can I edit the axis?

      Thank you very much for helping

       

      Giovanna

        • 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.

           

          Yours,

          Yuri

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

            One more - use a dual axis.