8 Replies Latest reply on Jun 19, 2018 4:40 AM by Bryce Larsen

    How to calculate time duration that starts from specific timestamp yesterday till specific timestamp today

    Rajeshwari Guddeti

      Hi,

       

      I have a data which have list of jobs. Report should display real time summary of jobs that are all running for a current day. Jobs generally starts at 06:00PM everyday. So, I  want to see all jobs that run from 6:00 PM until 5:45 PM on following day. 

       

      Tableau by default considers starting time as 12:00:00AM when relative filter is selected for Today. I want to custom define the starting time and ending time so as to get the all the relevant jobs for the duration i'm looking for.

       

      Can someone help me with calculation that need to be considered so as to get jobs that runs from 6:00:00PM for today until 05:45:00PM following day. Or it can be also jobs that run from  6:00PM yesterday till 5:45PM today.

       

      Please find attached is the excel sheet and tableau workbook.

       

      Any help would be greatly appreciated!!