Creating Measures and Dimensions Using LookML Reviews

ad. 5 "Lastly, add the SQL parameter. For this dimension, you're telling the SQL parameter to pull from the pre-existing traffic_source field where the value equals "Email”." It doesn’t work this way. It doesn’t only pull traffic_source where it’s equal to Email, such a dimension would only have “Email” as value. You should rewrite this explanation. It creates a new dimension with yes/no based on traffic_source value. "Note: When creating percentage measures, it is often useful to make sure you are not dividing by zero in the percentage calculation. This can be done through the NULLIF SQL function. sql: 1.0*${total_sales_email_users} / NULLIF(${total_sales}, 0) ;; " You sure about that? You’re sure if total_sales is null and we replace it with 0, we won’t get a division by 0 error? ;) Also, why is there a 1.0*?

Zofia G. · Reviewed 6 أيام ago

Krystian Ł. · Reviewed 6 أيام ago

Marc B. · Reviewed 6 أيام ago

Ivonne C. · Reviewed 6 أيام ago

Anandakumar V. · Reviewed 6 أيام ago

Yunfei B. · Reviewed 7 أيام ago

Ashish S M. · Reviewed 7 أيام ago

dinesh s. · Reviewed 7 أيام ago

AKSHAT A. · Reviewed 7 أيام ago

Gaurav B. · Reviewed 7 أيام ago

dimensionとmeasureに対する理解が深まりました

友紀 芳. · Reviewed 7 أيام ago

Piotr Ż. · Reviewed 7 أيام ago

Loraine P. · Reviewed 7 أيام ago

Seema G. · Reviewed 7 أيام ago

Dat L. · Reviewed 8 أيام ago

ivan g. · Reviewed 8 أيام ago

Marcin K. · Reviewed 8 أيام ago

Helene C. · Reviewed 8 أيام ago

asdfgdasf

Henrik Brenne F. · Reviewed 8 أيام ago

Jouni M. · Reviewed 8 أيام ago

Abdulaziz A. · Reviewed 9 أيام ago

Naveen K. · Reviewed 9 أيام ago

PASUPULETI B. · Reviewed 9 أيام ago

good

Rashmi J. · Reviewed 9 أيام ago

Viviana Marcela F. · Reviewed 10 أيام ago