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

    Multiple Conditions Using Time

    Christina Reid



      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.