Is there a way to group together all London Boroughs so it can be tracked as “Greater London”?
@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
1 Like