What’s the best way to making sure a Notebook, if get gets triggered at let’s say 7 pm pacific time today, shows data from 00.00 to 24.00 today pacific time, even though the day isn’t over yet.
I believe you will first need to set your query time explicitly in the Notebook: Execute Node as the end of the day (or whichever time you would like). Then your inputs should be set to pull data for “query time minus 24 hours,” giving a full calendar day. Some math will also have to be done to convert to the Pacific timezone.
It was also suggested that you could use a Timer Node with a cron string to trigger your Notebook at the same time daily.
How would I set up to run a notebook for a specific 24 hour day in the past?
When selecting Input data and custom time range, I can set specific fixed start and end time, but I don’t see how I can set those dynamically when executing a notebook from a workflow on demand.
You should be able to do this using the Query Time:
If you set all of your inputs to be the last 24 hours of data, you can change the Query Time to pick which 24 hours you want.
In this image, the example is 7 days. But the concept applies to you:
You will just change your query time when you kick off the notebook using the Notebook: Execute Node.