Group "Greater London" together


#1

Is there a way to group together all London Boroughs so it can be tracked as “Greater London”?


#2

@Woody You can have some custom logic in Redshift or Snowflake:

SELECT
  CASE
    WHEN geo_region_name IN ({{list of London borough names}}) THEN 'Greater London'
    ELSE geo_region_name
  END AS geo_region_name
FROM
  atomic.events