About Connor_Slevin

Connor_Slevin · 08-06-2020

Using the create custom dimension field in Looker (screenshot below) I want to group rows into one label. For example: Campaign Name Row 1: UK_oxfordstreet Row2: UK_uxbridge Row3: UK_clapham Can I create a new dimension with a rule saying if Campaign...

Connor_Slevin · 07-31-2020

I have a dimension with the naming convention: market_region_operating system_date I want to extract the operating system into its own dimension but cannot use the substring function as the number of character prior to the operating system varies and...

Connor_Slevin · 08-07-2020

I got it working this way: if(contains(${utms.campaign}, “ios”) ,“IOS”,if(contains(${utms.campaign}, “and”) ,“Android”,""))

Connor_Slevin · 08-07-2020

@Shekiaya if I want to create multiple labels in the same dimension how do I do this? For example: Row 1: UK_oxfordstreet Row2: UK_uxbridge Row3: UK_clapham Row4: UK_kirkby Row5: UK_seaforth Campaign Name contains “oxfordstreet” OR “uxbridge” OR “cla...

Connor_Slevin · 08-06-2020

Shekiaya: if(contains(string_to_search, “oxfordstreet”) OR contains(string_to_search, “uxbridge”) OR contains(string_to_search, “clapham”),“London”,"") Thank you! This looks like it’s working perfectly.

Connor_Slevin · 08-03-2020

Thanks for the help so far guys. I just want to say that I am not a programmer and don’t use SQL often and don’t have access to this. Our data warehouse is Snowplow. I guess I am trying to do this inside Looker itself, without needing to a new field ...

My Stats

Connor_Slevin's Bio

Badges Connor_Slevin Earned

Recent Activity

Create labels based on dimension contains "search term"

Return the searched substring from the string

Re: Create labels based on dimension contains "search term"

Re: Create labels based on dimension contains "search term"

Re: Create labels based on dimension contains "search term"

Re: Return the searched substring from the string