1 Reply Latest reply on Jul 2, 2018 2:38 AM by Mahfooj Khan

    Setting Time filter to choose the system time Automatically

    Rajesh Kota

      Hello,

       

      I have a date selector, Time Filter in my view.

       

      Is there any way to set the Time Filter to choose the system time automatically when you open the dashboard.

       

      For instance, when you open the dashboard @ 10:00:00AM the time filter should show 9:30:00AM - 10:00:00AM data for current date.

       

       

      Any help would be appreciated. Thanks in advance.

        • 1. Re: Setting Time filter to choose the system time Automatically
          Mahfooj Khan

          Hi Rajesh,

           

          Using NOW() function you can get the system datetime in your view whenever you launch your dashboard or refresh the data source.

           

          However, the you way wants the filter should work is something different. To have any filter on any discrete/continuous fields in our view, only criteria is fields should comes from the data source. If you've any datetime field which captures up to date information of every records then you may achieve this.

           

           

           

          Mahfooj