Hi
I am a newbie to looker. How do i create a custom dimension by concatenating three dimensions that we currently have?
1 Like
Hi @DebbieFCMSB - Assuming you have explore access to create custom dimensions, and that the existing dimensions are of string type, you should be able to use the concat string function:
If you have developer access and want to save the definition into your LookML model, I would just directly write the concatenation SQL into the new dimension using the relevant function/operator for your SQL dialect
2 Likes