bi-lookertraining.online

Looker Training
Menu
Home
looker
Creating Custom Dimensions

Creating Custom Dimensions

Custom dimensions are created using dimension parameter. The dimension name should be unique in the view.

We can create custom dimensions from existing dimensions.

For example if we need to create Full Name using First Name & Last Name, we should create a custom dimension as below,

dimension: first_name {
type: string
sql: ${TABLE}.first_name ;;
}

dimension: last_name {
type: string
sql: ${TABLE}.last_name ;;
}

dimension: full_name {
type: string
sql: ${first_name} || ‘ ‘ || ${last_name} ;;
}

using case statement in custom dimensions,

Share
Tweet
Email
Prev Article
Next Article

Leave a Reply

Cancel reply

bi-lookertraining.online

Looker Training
Copyright © 2021 bi-lookertraining.online
Theme by MyThemeShop.com

Ad Blocker Detected

Our website is made possible by displaying online advertisements to our visitors. Please consider supporting us by disabling your ad blocker.

Refresh