7 Replies Latest reply on May 3, 2018 6:57 AM by Zhouyi Zhang

    Date Missing issue

    rakesh jadhav

      Hi Team,

       

      PFA of .twbx File,

      I am facing issue in  undefined dates ,means as you can see in sheet I do have Target Line as Amber colour and actual as Blue colour,the issue I am facing is as in excel sheet I don’t have  some date in Date in Target vs actual sheet (as 07 April 2018, 08 April 2018 and so on) but I need so show all date of that month means april month 01 April 2018 to 30 April 2018 and communitive function of that.

      And also for actual value for date (07 April 2018, 08 April 2018 and so on) we need communitive function means what 06 April 2018 value is we need same  for Actual same for ( 07 April 2018, 08 April 2018 and so on) .

      What the previous date value we have for actual same will be remain for remaining two days .

      Please let me know how to achieve this issue.

      Thanks in advanced.

       

      Rakesh Jadhav