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

Giovanna

• ###### 1. Re: Time Series and Axis range

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

One more - use a dual axis.