3 Replies Latest reply on Sep 17, 2018 2:25 PM by Gerardo Varela

    Tableau Line Chart Representation

    Ronak Modh

      Hello Users,

       

      I have a question of how to show timeline for 3 consecutive years (2016,17 & 18) but only for last week of each quarter (i.e., week 13,26,39 & 52). I want to see the sales happened in last week of each quarter for 3 different years for different regions(Americas, EMEA and APEC). I would like to elaborate in the picture what I am looking for. Kindly see the attachment.

       

      Now, I would also like to show you the data that I have. I have Fiscal year, Fiscal Quarter ID as well as Fiscal week of year ID (but not date type and if I convert it to date type it does not function properly). See below the field that I have but these are number type and not date.

       

      I want to plot a line chart to show sales in USD for last week of each quarter for 3 different years for different regions. Please see the screenshot below:

       

      Kindly help me getting a result I have attached with this question.

       

      I appreciate all of you who always help and help me learn more.

      P.S.: Due to very large amount of dat I cant attach .twbx file. I have attached .twb file. Kindly help.

       

      Regards,

      Ronak Modh