4 Replies Latest reply on May 15, 2019 3:41 PM by Christina Reid

    Multiple Conditions Using Time

    Christina Reid

      Hello,

       

      Attached is a packaged workbook with sample data created using Tableau Desktop version 2018.2.0.

       

      Issue: I am unable to exclude instances where the interval is 3:00 PM or after (through the end of the day) AND the Start Date does not equal the Completion Date.

       

      Business Case: Exclude records where we received a request at 3:00 PM or after which was not completed that same day in the calculation of average processing duration.

       

      The time is a dimension called Interval displayed in half hour increments with a string data type (i.e. 2:00 PM, 2:30 PM, etc.).

       

      I appreciate any assistance provided.

       

       

      Regards,

       

      Christina