2 Replies Latest reply on Mar 19, 2020 12:10 PM by Sinisa Mikor

    Smart Reports - Exact time frame for reporting

    Kenny Ng
      Share This:

      When using dynamic filter, Can I have an exact time frame for reporting

       

      scheduled report by last resolved time:

      reportstart timeend time
      report12020-01-01 12002020-01-08 1200
      report22020-01-08 12002020-01-15 1200
      report32020-01-15 12002020-01-22 1200

       

      I have tried the following

      filterresult
      pre-defined period: previous 7 daysinclude those cases resolved in the morning of 2020-01-08 in report1 and report2
      defined Value: dynamic Date: current date - 7 day to current date - 0

      it will include the generation time to filter,

      i.e: if generated on 2020-01-08 13:00, it will use 2020-01-01 1300 as the filter.

      Just concerning if the schedule is not triggered on 1200 exactly, will there be some case not included in any report. i.e.: case resolved at 2020-01-01 12:01, but the generation time of scheduled report is 2020-01-08 12:02