Simple Case Statement on a saved view
I'm having problem creating a simple case statement in one of my data sources.
CASE WHEN 'Metric' > 0 THEN 1 ELSE 0 END
I tried many ways of doing this check and none of them worked.
This specific data source is a saved view of 4 bigquery tables, and apparently I'm not having any problems with case statements in the regular tables.
Is case not supported on views?