5 Replies Latest reply on May 8, 2017 7:35 AM by Tom W

    How to convert Week Ending dates to Week Numbers and then display these week Numbers as columns.

    Mehal Patel

      Hi, I have a dimension of data called Week Ending, which basically states the end date of each week throughout the year. I would like to convert each week into a week number and then display each week number as headings within a Tableau Sheet. It then must show the relating data which involves how many hours were completed for that week. Can this be done? I have added a view of what I am aiming to achieve, obviously this is shown in Excel, as this is how we currently are reporting this, however it will hopefully give you an idea of what view we are trying to achieve in Tableau.

       

       

      Hope to hear from someone soon, thanks. If you need any more information let me know.