Search code examples
looker-studio

Failed to parse CASE statement. Google Data Studio


I'm getting an error when trying to add a CASE statement in Google Data Studio.

Failed to parse Case Statement

Where am I going wrong?

CASE
  WHEN _count_featues_null value = 0 THEN COUNT_DISTINCT(dataset name )
END

Solution

  • Try moving the COUNT_DISTINCT function (and checking the spelling of _count_featues_null?):

    COUNT_DISTINCT(CASE
        WHEN _count_featues_null value = 0 THEN dataset name
      END )