3 Replies Latest reply on Aug 6, 2018 10:20 AM by Alan Perez

    How to get the last value from the 15 min interval group

    Sravya Ginne

      Hi I am working on a project to get the values for the last 15 min. I have created a 15 min Group that grows according to the current time. For example if current time is 3:22 PM, it should show the values for last 15 min slot which is between 3:00 pm - 3:15 pm.

      For this I have created a 15 min Group which shows all the values using the below code in calculated filed.

       

      This gives the below values

      00:00 - 00:15

      00:15 - 00:30

      00:30 - 00:45

      00:45 - 00:60

      and so on till the end of the day

      23:00 - 23:15

      23:15 - 23:30

      23:30 - 23:45

      23:45 - 00:00

       

      Now I want the filter to automatically select the last value in the group. As you see in the below picture, I want the last value which is the last 15 min time frame in the filter to be automatically selected and  displays the bar chart.