cancel
Showing results for 
Search instead for 
Did you mean: 

Filtering for last 2 hours

edselv
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

1 REPLY 1

Benji
8 - Cloud Apps
8 - Cloud Apps

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.

Cheers,

Benji

benji@paldi.solutions 

Paldi Solutions | Sisense Experts for Embedded Analytics Tools