2 Replies Latest reply: Jul 12, 2018 2:10 AM by arjun rao RSS

    Rolling Seven days based on selection

    Yuvaraj G

      Hi all,

       

      I have tried to get the rolling seven days based on user selection and below things i have tried. Here the date has mentioned like when the work item has been approved that date only will be entered.

       

      Expression:

      Sum({< Date={‘>=$(=Date(Max(Date)-9))<=$(=Date(Max(Date)))’}>} [Number of Approved Items] )


      Created variable for based on user selection:

      vStartDate - Date(Max(Date)-9))

      vEndDate - Date(Max(Date))

      Sum({< Date={‘>=$(=Date($(vStartDate))<=$(=Date($(vEndDate))’}>} [Number of Approved Items] )

       

      DateNumber of Approved Items
      01-06-20181
      02-06-20183
      05-06-20182
      06-06-20182
      07-06-20188
      08-06-20184
      09-06-20182
      10-06-20182
      12-06-20182
      14-06-20182
      15-06-20182
      16-06-20182
      19-06-20188
      21-06-20186
      23-06-20183
      24-06-20182
      26-06-20184
      27-06-20185
      28-06-20187

       

      Expected Result:

      It should be shown the last seven days approved count default

       

       

      19-06-201821-06-201823-06-201824-06-201826-06-201827-06-201828-06-2018
      20242525273035

       

      If user select any particular date i want show the result from selection date to last seven days.

       

      For example: user selected date:14-06-2018

      then data should be shown from 14-06-2018 to 06-06-2018


       

      Regards,

      Yuvaraj