1 Reply Latest reply on Dec 2, 2013 2:16 PM by Tracy Rodgers

    Trouble with formatting dates and displaying dates on graph

    michael.chan.0

      Hello,

       

      I am having trouble displaying this data in a graph.  I want my axis to be based on Fiscal week to match my fiscal calendar (weeks 1 through 52).

       

      Below are the columns in my database:

      Year

      Month

      Week Number

      Sales

       

      I want to display the rolling 13 week of sales.  However, my Week Numbers are formatted to only be a number 1 through 5 (3rd month of each quarter has 5 weeks).

       

      For example:

      January - 2013 - Week 1

      January - 2013 - Week 2

      January - 2013 - Week 3

      January - 2013 - Week 4

      February - 2013 - Week 1

      February - 2013 - Week 2

      February - 2013 - Week 3

      February - 2013 - Week 4

      March - 2013 - Week 1

      March - 2013 - Week 2

      March - 2013 - Week 3

      March - 2013 - Week 4

      March - 2013 - Week 5

       

      How do I make tableau display the information in the format I am looking for?

       

      Thanks,


      Michael