Add a new rolling date filter to support the new functionality

XMLWordPrintable

    • Type: Feature Part
    • Resolution: Done
    • Priority: L3 - Default
    • 3.0.0-alpha1, 3.0.0
    • Affects Version/s: None
    • Component/s: backend
    • None

      We need to add a new date filter type to cover the case where users want to see data based on intervals that are either the current interval or the x number of previous completed intervals. This could be called 'rolling' or 'interval' date filter.

      AT:

      • the new date filter should not operate in floating windows but only look at full unit intervals, e.g. 1 day means the whole previous day not from the current time 24h back
      • documentation is updated
      • The new date filter post payload could look as follows:
      { 
        "type" : "rolling",
        "start": {
          "value" : 12345, // 0 for 'this' or number for 'last'
          "unit" : "days" // minutes, hours, days, weeks, months, quarters, years
        },
        "end" : null
      }
      
      Sample values: 
      Today: 0, days
      Yesterday: 1, days
      This month: 0, months
      last 2 years: 2, years
      

        This is the controller panel for Smart Panels app

              Assignee:
              Unassigned
              Reporter:
              Omran Abazeed
              Votes:
              0 Vote for this issue
              Watchers:
              0 Start watching this issue

                Created:
                Updated:
                Resolved: