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

EMS_Data_Guy

Posted 8 months ago·Last reply 7 months ago

4 comments

DRay

·7 months ago

Hi EMS_Data_GuyAstroraf,

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.

DRay

·8 months ago

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.

EMS_Data_Guy

OP7 months ago · Edited

The widgets themselves don't include a date field. I am aware of the functionality you describe when building pivots, breaking out a chart, or performing DIFF calculations. This does not solve the issue of a dashboard level filter.

The first forum post will not work since we don't use an Elasticube and I have no way of editing the source data.

The second forum post is actually by the guy that manages the Sisense integration for our vendor and again, doesn't appear to answer the question. That answer appears to address the ability to have date/time breakouts when building widgets/formulas but not filters.

To clarify, I am looking at setting a dashboard filter. When choosing a datapoint that is a date/time value, the only options under "Time Frame" are as shown here

For more information this is a sample of the data this dashboard is displaying:

The first widget simply displays a count of the records for that unit in the established time frame. If I try and get fancy and build a filter into a formula (COUNT ([# of unique incident number]), [En Route]) I wind up with the same issue. I can filter by specific hours of the day, but the "Time Frame" option does not let me go down to hours. I get the exact same dialogue box as the dashboard level filter.

DRay

·7 months ago

Thank you for the response. I'll see if I can find another solution for you.