Forum Discussion

pbi138's avatar
pbi138
Frequent Visitor
8 years ago

Streaming dataset filtering not working

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

 

Need Help

3 Replies

  • pbi138's avatar
    pbi138
    Frequent Visitor
    8 years ago

    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! (