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 days ago

Krystian Ł. · Reviewed 6 days ago

Marc B. · Reviewed 6 days ago

Ivonne C. · Reviewed 6 days ago

Anandakumar V. · Reviewed 6 days ago

Yunfei B. · Reviewed 7 days ago

Ashish S M. · Reviewed 7 days ago

dinesh s. · Reviewed 7 days ago

AKSHAT A. · Reviewed 7 days ago

Gaurav B. · Reviewed 7 days ago

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

友紀 芳. · Reviewed 7 days ago

Piotr Ż. · Reviewed 7 days ago

Loraine P. · Reviewed 7 days ago

Seema G. · Reviewed 7 days ago

Dat L. · Reviewed 8 days ago

ivan g. · Reviewed 8 days ago

Marcin K. · Reviewed 8 days ago

Helene C. · Reviewed 8 days ago

asdfgdasf

Henrik Brenne F. · Reviewed 8 days ago

Jouni M. · Reviewed 8 days ago

Abdulaziz A. · Reviewed 9 days ago

Naveen K. · Reviewed 9 days ago

PASUPULETI B. · Reviewed 9 days ago

good

Rashmi J. · Reviewed 9 days ago

Viviana Marcela F. · Reviewed 10 days ago