topic Change default time range based on current time in Dashboards & Visualizations

Change default time range based on current time

jlew715 — Thu, 25 Feb 2021 19:31:14 GMT

Hey all,

I need to have the default time range for a dashboard cover an overnight shift. This necessitates the time range change depending upon when the page is loaded:

Time user loads page	Time range	Description
00:00 - 17:59	@d-1d+18h to @d+6	18:00 yesterday to 06:00 today
18:00 - 23:59	@d+18h to @d+1d+6h	18:00 today to 06:00 tomorrow

After a few hours of searching the forums I haven't seen another example where this is done, and I can't for the life of me figure out how to do it. Any help or just a nudge in the right direction would be appreciated!

Thanks,

Re: Change default time range based on current time

ITWhisperer — Thu, 25 Feb 2021 19:30:57 GMT

-1d@d+18h to @d+6h

@d+18h to +1d@d+6h

Re: Change default time range based on current time

jlew715 — Thu, 25 Feb 2021 19:41:26 GMT

Ok, I can confirm those are the two ranges I need.

How / where do I specify those as the default? Where do I put the logic to say "IF the local time is after 18:00 but before 23:59, use @d+18h to +1d@d+6h ELSE IF the local time is after 00:00 but before 17:59, use -1d@d+18h to @d+6h"?

Re: Change default time range based on current time

ITWhisperer — Thu, 25 Feb 2021 19:58:18 GMT

Will this work

Earliest = +6h@d-6h

Latest = +6h@d+6h