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