Data Connector: GSC.
I have created a new calculated field ‘Resort’ using the following regex_match
CASE
WHEN REGEXP_MATCH(Landing Page, “(?i)./atherton-tablelands/.”)THEN “Atherton Tablelands”
WHEN REGEXP_MATCH(Landing Page, “(?i)./bairnsdale/.”)THEN “Bairnsdale”
WHEN REGEXP_MATCH(Landing Page, “(?i)./ballarat/.”)THEN “Ballarat”
WHEN REGEXP_MATCH(Landing Page, “(?i)./batemans-bay/.”)THEN “Batemans Bay”
WHEN REGEXP_MATCH(Landing Page, “(?i)./bathurst/.”)THEN “Bathurst”
WHEN REGEXP_MATCH(Landing Page, “(?i)./bowen-beachfront/.”)THEN “Bowen Beachfront”
WHEN REGEXP_MATCH(Landing Page, “(?i)./bright/.”)THEN “Bright”
WHEN REGEXP_MATCH(Landing Page, “(?i)./broulee/.”)THEN “Broulee”
WHEN REGEXP_MATCH(Landing Page, “(?i)./cairns/.”)THEN “Cairns”
WHEN REGEXP_MATCH(Landing Page, “(?i)./capricorn-yeppoon/.”)THEN “Capricorn Yeppoon”
WHEN REGEXP_MATCH(Landing Page, “(?i)./darlington-beach/.”)THEN “Darlington Beach”
WHEN REGEXP_MATCH(Landing Page, “(?i)./dubbo/.”)THEN “Dubbo”
WHEN REGEXP_MATCH(Landing Page, “(?i)./eastern-beach/.”)THEN “Eastern Beach”
WHEN REGEXP_MATCH(Landing Page, “(?i)./echuca/.”)THEN “Echuca”
WHEN REGEXP_MATCH(Landing Page, “(?i)./forster-tuncurry/.”)THEN “Forster Tuncurry”
WHEN REGEXP_MATCH(Landing Page, “(?i)./halls-gap/.”)THEN “Halls Gap”
WHEN REGEXP_MATCH(Landing Page, “(?i)./jindabyne/.”)THEN “Jindabyne”
WHEN REGEXP_MATCH(Landing Page, “(?i)./lake-somerset/.”)THEN “Lake Somerset”
WHEN REGEXP_MATCH(Landing Page, “(?i)./merimbula-beach/.”)THEN “Merimbula Beach”
WHEN REGEXP_MATCH(Landing Page, “(?i)./mildura-riverside/.”)THEN “Mildura Riverside”
WHEN REGEXP_MATCH(Landing Page, “(?i)./murramarang/.”)THEN “Murramarang”
WHEN REGEXP_MATCH(Landing Page, “(?i)./myall-shores/.”)THEN “Myall Shores”
WHEN REGEXP_MATCH(Landing Page, “(?i)./ocean-beach/.”)THEN “Ocean Beach”
WHEN REGEXP_MATCH(Landing Page, “(?i)./palm-cove/.”)THEN “Palm Cove”
WHEN REGEXP_MATCH(Landing Page, “(?i)./phillip-island/.”)THEN “Phillip Island”
WHEN REGEXP_MATCH(Landing Page, “(?i)./phillip-island/.”)THEN “Phillip Island”
WHEN REGEXP_MATCH(Landing Page, “(?i)./port-arthur/.”)THEN “Port Arthur”
WHEN REGEXP_MATCH(Landing Page, “(?i)./port-campbell/.”)THEN “Port Campbell”
WHEN REGEXP_MATCH(Landing Page, “(?i)./portland-bay/.”)THEN “Portland Bay”
WHEN REGEXP_MATCH(Landing Page, “(?i)./port-macquarie/.”)THEN “Port Macquarie”
WHEN REGEXP_MATCH(Landing Page, “(?i)./shellharbour-beachside/.”)THEN “Shellharbour Beachside”
WHEN REGEXP_MATCH(Landing Page, “(?i)./south-west-rocks/.”)THEN “South West Rocks”
WHEN REGEXP_MATCH(Landing Page, “(?i)./stockton-beach/.”)THEN “Stockton Beach”
WHEN REGEXP_MATCH(Landing Page, “(?i)./sydney-lakeside/.”)THEN “Sydney Lakeside”
WHEN REGEXP_MATCH(Landing Page, “(?i)./tathra-beachfront/.”)THEN “Tathra Beachfront”
WHEN REGEXP_MATCH(Landing Page, “(?i)./treasure-island/.”)THEN “Treasure Island”
WHEN REGEXP_MATCH(Landing Page, “(?i)./victor-harbor/.”)THEN “Victor Harbor”
WHEN REGEXP_MATCH(Landing Page, “(?i)./warrnambool-riverside/.”)THEN “Warrnambool Riverside”
WHEN REGEXP_MATCH(Landing Page, “(?i)./woodgate-beach/.”)THEN “Woodgate Beach”
WHEN REGEXP_MATCH(Landing Page, “(?i)./yarrawonga-mulwala/.”)THEN “Yarrawonga Mulwala”
Else “no resort”
END
Now, when I use the above calculated _field as table filter OR Line Chart filter, it works fine. But when I try to use it as a control dropdown, it doesnt show the correct data, neither in the table nor in the line chart.
Please help.