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.

Question

Asutosh Jha · Accepted Answer

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]

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.

Your answer

1 Answer

More Tableau discussions

Learn & Explore

Popular Tutorials

Tableau Interview Q&A

Latest Tableau Blogs

Want answers to more Tableau questions?

Stay in the loop — it’s free

You’re on the list!