Create two parameters, one for start time and one for end time. These should be linked to the date/time field in your data. Create a calculated field that says [date/time]>= startTime AND [date/time]<= endTime. This you place in the filter shelf and set to TRUE. Now you will see the processes that run during the timeframe you set with the parameters.
Thanks for your reply.
How could i set dynamically to always consider yesterday's specific time stamp till today's specific time stamp.
This timestamp should be automatically changed to yesterdays timestamp depending on the current day i'm looking at.
1 of 1 people found this helpful
Hello! Would something like this work?
I simply added 6 hours to each timestamp since you just want to see things the start running as of yesterday at 6pm. As such, adding 6 hours makes it easy to compare to Today's date (after wrapping within DATE(). Unsure how important it is to take 5:45 as end or up until 5:59pm is sufficient. If 5:45pm is important:
In the calculated field you might look at today()-1 or start date/time -1 day using the datediff function. Datediff(‘day’,[dateTime],today()-1). Just thinking on the run here. Can look at more later today.
Sent from the iPhone of Timothy Dines.
Rajeshwari Guddeti - one other thing to consider from my post above is what you want "today" to be. Do you want to see jobs that started running last night and that are running today? Or do you want to see jobs that ran starting two nights ago and up to last night? Or do you want it to be based on time of day - eg. looking at dashboard at noon will show one thing and looking at it at 8pm will show another?
Sorry if this adds complexity/confusion, but something to take into consideration!
Your solution worked for me..
Thanks a lot!!...@
Your second clarification is bit confusing for me.. First solution given by you perfectly worked for me..
Heh, glad first one worked! Believe in original post you mentioned 6pm last night to 545pm today. The second line was to ensure the jin executed before 545pm. But wasn’t sure if this was necessary.