Showing results for 
Search instead for 
Did you mean: 

Filtering for last 2 hours

Sisense Team Member
Sisense Team Member

Hi Sisense Team,

Wondering if anyone has good suggestions on how to setup a filter to show only the last two hours of data. Data is updating every 3 minutes (datetime structure in screenshots). I would like to filter for the last two hours and would like to have users be able to quickly apply this filter. Any suggestions?

Screen Shot 2022-11-09 at 16.23.44.png


11 - Data Pipeline
11 - Data Pipeline

Hi @edselv ,

There are actually a few ways to tackle this use case.

1. You can solve it by creating "dim time" in your EC and adding an hour custom column to your table, joining between both, and then you can filter the last two hours by combining the date filter as well.

2. Change the date column to epoch time and by that you are actually changing it to numeric field. Add a front-end manipulation so the filter will appear in "normal" hour format.

We recently completed a few projects dealing with this use case and would be delighted to hop on a call with you to demonstrate them.

You can DM me and I will send you an invitation to schedule a call.



[email protected] 

Paldi Solutions | Sisense Experts for Embedded Analytics Tools


8 - Cloud Apps
8 - Cloud Apps

Curious if you ever figured this out?