10 Replies Latest reply on Feb 14, 2019 10:17 AM by Aishwary Srivastava

    Latest 5 weeks YoY growth rate

    Aishwary Srivastava

      Hello,

       

      I am new to Tableau and I am building a dashboard to show latest 5 weeks data along with their YoY growth rate. I have only one order date field and I have tried multiple methods to get latest 5 weeks and their YoY but it doesn't seems to be working. However, Latest 5 weeks of the data I am able to get by using the below code:

       

      DATEDIFF('week',(DATETRUNC('week',[Day])),{MAX(DATETRUNC('week',[Day]))}) <= 4

       

      But showing their YoY is a challenge. Please assist.