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 gün ago

Krystian Ł. · Reviewed 6 gün ago

Marc B. · Reviewed 6 gün ago

Ivonne C. · Reviewed 6 gün ago

Anandakumar V. · Reviewed 6 gün ago

Yunfei B. · Reviewed 7 gün ago

Ashish S M. · Reviewed 7 gün ago

dinesh s. · Reviewed 7 gün ago

AKSHAT A. · Reviewed 7 gün ago

Gaurav B. · Reviewed 7 gün ago

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

友紀 芳. · Reviewed 7 gün ago

Piotr Ż. · Reviewed 7 gün ago

Loraine P. · Reviewed 7 gün ago

Seema G. · Reviewed 7 gün ago

Dat L. · Reviewed 8 gün ago

ivan g. · Reviewed 8 gün ago

Marcin K. · Reviewed 8 gün ago

Helene C. · Reviewed 8 gün ago

asdfgdasf

Henrik Brenne F. · Reviewed 8 gün ago

Jouni M. · Reviewed 8 gün ago

Abdulaziz A. · Reviewed 9 gün ago

Naveen K. · Reviewed 9 gün ago

PASUPULETI B. · Reviewed 9 gün ago

good

Rashmi J. · Reviewed 9 gün ago

Viviana Marcela F. · Reviewed 10 gün ago