Tableau: COUNTD using IF statement

Question

I have a tableau data grid that I need to count distinct records. If the status is Complete distinct count the RecordID IF [Status] = "COMPLETE" THEN COUNTD([Survey ID]) ELSE 0 END), but I am getting an error "Cannot mix aggregate and non-aggregate comparisons or results in IF expression". Any ideas?

Answer 1

You are close, but you need to rearrange the order of things.

COUNTD(IF [Status] = "COMPLETE" THEN [Survey ID] END)

This will return a Survey ID if the Status is 'COMPLETE' otherwise it will return a NULL to the COUNTD function. NULLs are ignored, so they won't be counted.