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