Forum Discussion

EMS_Data_Guy's avatar
EMS_Data_Guy
Data Storage
12-01-2025

Filter Dashboard by Last 24 Hours

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'.

Filters

2 Replies

  • DRay's avatar
    DRay
    Sisense Employee
    12-03-2025

    Hello EMS_Data_Guy​,

    Thank you for reaching out.

    When you create a widget in your dashboard that includes a date field, Sisense automatically breaks the data down by year. You can shorten this to Quarters, Months, Weeks, Days, Hours, and so on. And, for Pivot and Table widgets with live data models, you can set the breakdown to a granularity of Seconds.

    See Adding Widgets to a Dashboard. The section Managing Date and Time Fields explains how to set the date and time resolution for ElastiCubes and Live models.

    This question also comes up in the community occasionally, I found a few other posts with similar requests that may help you.

    Filtering for last 2 hours | Sisense Community

    Filtering w/ Time Frame on Hours Intervals | Sisense Community

    I hope that helps. Please let us know if you need any more help with this.

     

  • DRay's avatar
    DRay
    Sisense Employee
    12-12-2025

    Hi EMS_Data_Guy​Astroraf​,

    I’m following up to see if any of the solutions I offered worked for you.

    If so, please click the 'Accept as Solution' button on their post. That way others with the same questions can find the answer. If not, please let us know so that we can continue to help.

    Thank you.