3 Replies Latest reply on Oct 11, 2018 8:42 PM by Hideki OGAWA

    Select dates (years) to be shown and change date type (Tbl 18.2)

    Tim Guth

      Hey guys,

       

      I am a student currently learning how to learn Tableau - sorry for stupid questions. I am using Tableau Desktop for Teaching 2018.2 version.

       

      I have a table displaying values for male, female, and total ("person") for the years 2005, 2012, and 2016. I got 2 questions:

       

      1. When inserting the table, the column "year" is formatted as follows: "01.01.2015" even though the value in the original table is "2005". That wouldn't be such a big problem, however, Tableau sets the corresponding data point for 2005 five slidely left to the actual "2005" on the axis. It seems that the "2005" on the axis is set to the middle of the year 2005. Can I change this to a way that the data point is displayed vertically above 2005? I tried seeting the years to string and use a Date function but that makes the distances between 2005, 2012, and 2016 equal, even though they are not equal (7 years and 4 years difference).
      2. I only got data points for 2005, 2012, and 2016. However, tableau also displays all the years in between. Is there a way of erasing those years from the visualisation?


       

      Question1.JPG

       

      Thanks a lot for your help!

       

      Best

      Tim

       

      #beginnersatwork