Using Tableau Desktop Windows 2020.4.1
I have a DATE field, [Assignment End], with many NULL values for assignments that are ongoing, or "Open." When I place this field into the Rows shelf and select Exact Date/Discrete, the dates appear as I format them (m/d/yyyy) but I have no "Edit Alias" option, so I cannot display NULL values as "Open."
I can use a calculated field with IFNULL(STR([Assignment End]), "Open") but then the date appears as "yyyy-m-d" and re-formatting it seems laborious and likely to slow the worksheet response time. Is there a faster way to have the original field display "Open" when it is Null, and its value in m/d/yyyy format when a date has been entered?
There's a workaround detailed here...Turning "Null" Dates into Blank Values in Tableau - InterWorks...
where you temporarily change the data type of the date field to String, alias Null on the string field, and then change the data type back to Date and the alias for Null is retained.
