Filtering for last 2 hours

[edselv]

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?

 

[Benji_PaldiTeam]

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

[email protected] 

Paldi Solutions | Sisense Experts for Embedded Analytics Tools

[ascott011]

Curious if you ever figured this out?