I need to create a calculated field using this logic: # of casesIF status = closed then use the date resolved fieldIF the date resolved is blank then want to use date closed field.

942 Asked by CamelliaKleiber in Tableau , Asked on Nov 7, 2019

For this, you can write a calculated field with the code like below-

IF [STATUS] = 'Closed' THEN [Date Resolved]

ELSEIF ISNULL([Date Resolved])=TRUE THEN [DATE_CLOSED]

Your Answer