Hi all,
Im creating a Looker Dashboard. I would to create a conditional field where anything less than 1 minute is Shorts else long form video. I wrote this formula, however, all the videos are showing up as long form video. Can anyone please assist here?
CASE
WHEN REGEXP_CONTAINS(Video Length, "^00:00:") THEN 'Shorts'
ELSE 'Long video'
END