Making rows of views visible for short time

[Madhav_More]

Hi just want to share this trick where in the view the data of the particular row will be visible only for a specific time.
Go to data>>Slice>>Row filter condition and input ( totalminutes(now()-“03:15:30”)-totalminutes([Access datetime]-“03:15:30”)<15)
where view will be visible for 15 mins

[Steve]

Note that you MAY run into performance and/or battery-charge problems as your data set grows. A row filter expression with NOW() has to be reevaluated every second for every row of the underlying table.

[Madhav_More]

Thanks, I didn’t know that. Just implemented this and it worked so shared it here. But I will definitely keep this in mind.

[Jonathon]

Steve, I have taken to using UTCNOW() for timestamps and convert to local time with a virtual column as [utcTimestamp]-(UTCNOW()-NOW())

Is there a preferred way to do this? I’m aware of the usertzoffset() formula but I’ve not been using it.

[Steve]

The way you’re doing it is how I’d do it.