3 Replies Latest reply on Mar 23, 2016 3:29 PM by Shivang Desai

    Shifting a graph value one week back to last year

    Shivang Desai

      Hi All,


      My current work involves shifting a graph value to 1 week back. I have successfully done 90% of it.


      Now only a small issue is shifting the graph value on week 01 2015/16 year to week 53 2014/15.


      As you can see below in Screenshot 1, starting value of 2016/17 is on week 02. But in Screenshot 2 I shifted that value to week 01 using a calculated field "Shifted Date"


      Shifted Date logic:

      IF [Date_Financial Year] = "2016/17" THEN [Date_Financial Week]

      ELSE "Week " + RIGHT("00" + str(int(RIGHT([Date_Financial Week],2)) - 1),2) END


      This shifts the graph value to one week back.


      But now just one issue is there, as you can see in screenshot 2 there is "Week 00" value of 2015/16 (purple line)  which I want to convert to "Week 53" of 2015 (Blue line).


      How can I implement using above calculation or any other logic?



      Screenshot (64).png


      Screenshot 1


      Screenshot (63).png                     


      Screenshot 2

      Screenshot (62).png



      Kind Regards,

      Shivang Desai