Streaming dataset filtering not working

[pbi138]

Hi all,

I using a streaming dataset to visualize real-time IoT data. I would like to show only data in the past 24 hours, so I am trying to use a relative date filter like in the screenshot but it is not working. 

It only filters yesterday data, that is 24 Jan (it's now 25 Jan 10am). Could that be a time zone problem? It's still 24 Jan 11pm UTC? 

Thanks for your help,

Tom

Edit: Please see my new question below. I am trying to get a "Top N"filter working now. Thanks

[pbi138]

So I have figured out that it is indeed a timezone issue. The easiest way to resolve this would be to use a "Top N" filter and just plot N latest values. Easy. Except the filter is not working. If I select top 10 values ordered by latest time stamp (called recordstart) I get 21 values back.

Before "Top N" filter. Highlighted are values I would expect to see after applying the filter.After filter. Highlighted are values I would expect to see. But there is bunch of other values. The ordering is extremely weir as there are values from December as well! (

[pbi138]

Anyone?

[pbi138]

And here is the screenshot: