Hi
I have a report built on a pivot table (pivot is on 2 date columns), showing project timelines.
I'm using a parameter (badly called Filter) so that end users can select to see all the timeline, or only to sort the viz by 'FCS date' (FCS date is the last milestone in a project), in ascending or descending order.
For this sorting I'm using a ranking (FCS-ranked).
The result is correct (the projects are sorted by FCS-ranked), but the dates are all clogged on the right because Tableau has the timeline start for some reason in 1900 :
Do you have any idea why this is happening ? How can I prevent Tableau from displaying such a large time range ?
Do you know a workaround ?
Thanks if you can help me
Myriam
Thanks a lot Swaroop, it was close to what I expected. However I needed to exclude the rows that had a start date in the filter.
I finally found the trick. It was because the axis range was not homogeneous. I had a mix of fixed and automatic which, for some reason I'm not clear about, screwed up axis rescaling.
When setting start and end consistently (either both fixed, or both automatic), the axis scales nicely :
Thanks a lot for spending time on my question, really appreciate it.
