4 Replies Latest reply on Jul 26, 2016 1:59 PM by Timothy Fitten

    getting complete and incomplete return for course completion

    Timothy Fitten

      I am trying to get the my dimension (which I changed from date/time to a string) to return a value of "complete" or "incomplete" using the following formula: CASE [Ash Savi] WHEN "2016" THEN 'COMPLETE' ELSE 'INCOMPLETE' END.  The response from Tableau gave me all "complete".  The string of data contains time and date information e.g. 2016-07-01 10:08; of which I was hoping Tableau would look at all strings and see if "2016" was there and return me a value of complete while returning a value of incomplete for anything without "2016" in it.  What am I presuming wrong about Tableau?