Creating Measures and Dimensions Using LookML avis

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. · Examiné il y a 6 jours

Krystian Ł. · Examiné il y a 6 jours

Marc B. · Examiné il y a 6 jours

Ivonne C. · Examiné il y a 6 jours

Anandakumar V. · Examiné il y a 6 jours

Yunfei B. · Examiné il y a 7 jours

Ashish S M. · Examiné il y a 7 jours

dinesh s. · Examiné il y a 7 jours

AKSHAT A. · Examiné il y a 7 jours

Gaurav B. · Examiné il y a 7 jours

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

友紀 芳. · Examiné il y a 7 jours

Piotr Ż. · Examiné il y a 7 jours

Loraine P. · Examiné il y a 7 jours

Seema G. · Examiné il y a 7 jours

Dat L. · Examiné il y a 8 jours

ivan g. · Examiné il y a 8 jours

Marcin K. · Examiné il y a 8 jours

Helene C. · Examiné il y a 8 jours

asdfgdasf

Henrik Brenne F. · Examiné il y a 8 jours

Jouni M. · Examiné il y a 8 jours

Abdulaziz A. · Examiné il y a 9 jours

Naveen K. · Examiné il y a 9 jours

PASUPULETI B. · Examiné il y a 9 jours

good

Rashmi J. · Examiné il y a 9 jours

Viviana Marcela F. · Examiné il y a 10 jours