2 Replies Latest reply on Aug 22, 2016 8:38 AM by Courtney Cecelia

    IF/When Statement in Tableau

    Courtney Cecelia

      Hello, I am fairly new to tableau and it's programming language. I need to create a calculated field that only returns the Max DOS when the Processed field is set to True. I have tried the formula several different ways and haven't been able to get it to work.

       

      There will always be a Max DOS field that has been processed, however there are sometimes DOS that haven't been processed. So, currently, I have a calculated field returning the MAX DOS and then a filter on Processed = True, but realized when there is a greater DOS that hasn't been processed, the row disappears from the report. I want them to always show, but only reporting the max DOS that has been processed.