topic Re: Streaming dataset relative date filtering not working in Developer

Streaming dataset filtering not working

pbi138 — Wed, 24 Jan 2018 23:59:30 GMT

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

Re: Streaming dataset relative date filtering not working

pbi138 — Wed, 24 Jan 2018 23:04:02 GMT

And here is the screenshot:

Re: Streaming dataset relative date filtering not working

pbi138 — Wed, 24 Jan 2018 23:58:23 GMT

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

Re: Streaming dataset relative date filtering not working

pbi138 — Mon, 29 Jan 2018 22:19:44 GMT

Anyone?