Filter Dashboard by Last 24 Hours | Help and How-To

EMS_Data_Guy · 2025-12-01T19:13:46.848000Z

In my industry, we mostly work 12 or 24 hour shifts with the most common shift change time being 0600. I have a great dashboard built that looks at the last day and calculates time on task. The only problem is that the only filter that comes close is 'Yesterday' which is looking at 00:00-23:59 on the last calendar day. I need to be able to look at 06:00 on day one to 06:00 the next day. I tried a couple of tweaks by using the 'Advanced' feature under the filter but none of them worked. Including trying a fractional offset of 0.75. My goal is to have this auto run at 0800 every morning. So, the 'advanced' tab would look like this, { "last": { "count": 24, "offset": 2 } } I can't make that work now though because the advanced tab only lets you edit the filter for the time period selected and hours isn't a choice. We are using an embedded version of Sisense so I can't edit anything in 'The Cube'.

MoreDiscussions

Filter Dashboard by Last 24 Hours | Help and How-To | Sisense Community