Using a set time with a dynamic date as a filter condition in a dashboard/report

[John51]

Hi everyone, 

I'm trying to build a dashboard report that will show one of our teams all the work that they need to complete today, but I've got a complexity that I'm not sure how to deal with. 

The current dashboard looks at a variable called "SLA Due" (which is a date), and says "SLA Due > On > Today". 

The complexity is that, due to our setup, the team needs to also have completed any work due on or before 09:00:01 the following day. 

I can't say "SLA Due > On or before > Tomorrow", because I'll get the whole of tomorrow's work, but I can't find a way to filter for "On or before tomorrow at 10am"? I've tried using Trend to specify a time, but I can't think of a way to combine that to say "on or before 10am tomorrow".

Thanks in advance!

[Maik Skoddow]

Hi @Alex John ,

there is no simple answer, but a really good solution is described at the following article: https://community.servicenow.com/community?id=community_article&sys_id=7b5b60971b789010a59033f2cd4bc...

Kind regards
Maik

If my answer replied your question please mark appropriate response as correct so that the question will appear as resolved for other users who may have a similar question in the future.

[Maik Skoddow]

Hi @Alex John ,

Did my reply answer your question?

If so, please mark appropriate response as correct so that the question will appear as resolved for other users who may have a similar question in the future.

If not, please tell me what is still missing.

Kind regards
Maik

[John51]

Hi Maik, 

Thanks for your response, it's much appreciated. 

It didn't solve my query, but, it did set me off on the right path. I'm certainly not proficient in javascript, but I couldn't see anything in that article about using a dynamic day (i.e. "tomorrow"), and a set time (i.e. "10am", or "09:00:01"). It was very interesting, however, and I've bookmarked it as I can see a few applications for it already. 

What I did to solve my issue was much simpler, as I was overthinking the issue and setting an OR filter at a lower level when it should have been at the header level. I ended up with two filters on my dashboard at the top level: 

SLA Due > On > Today

OR

SLA Due > On > Tomorrow AND SLA Due > Trend > On or before > 10am

It's not perfect, as I really only care about cases that are due tomorrow that specifically have the SLA Due time of "09:00:01", however, for my current skill level I'm happy with the performance of this report. 

Thanks again!