3 Replies Latest reply on Jun 13, 2018 9:16 AM by Anusha H

    how to get week number and year number together ?

    Anusha H

      Hello All,


      I have a field called 'SNAP_DATE' which needs to be represented in the form of 'week- Year'


      Eg : This week will be 2418 or 242018.


      Is it possible to get this in Tableau ?


      I tried to do this in a crude way:


      First got Week = week(SNAP_DT) and Year = year(SNAP_DT) as separate columns and tried to concatenate these in a 3rd column after making both the first teo columns as discrete, Week-Year = [Week]+[Year] but this doesnt work as Tebleau just adds the two numbers.