I have put together an orders report and one of the dimensions is broadcast date. Some of my orders do not have a broadcast date so the these show 'null' how can I update this to show a blank.
The below worked on some text but not on a date:
IFNULL([Broadcast Date], '')
You may have to convert the date to a string: IFNULL(STR([Broadcast Date]),'').
If you still want to sort by date and the string-based date format doesn't sort properly, you could add [Broadcast Date] to the view and hide the column.
Become a Viz Whiz on the Forums!
Support the Community and master Tableau.
Retrieving data ...