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.

       

       

      Thanks,

      Anusha