Criar medições e dimensões com o LookML avaliações

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. · Revisado há 6 days

Krystian Ł. · Revisado há 6 days

Marc B. · Revisado há 6 days

Ivonne C. · Revisado há 6 days

Anandakumar V. · Revisado há 6 days

Yunfei B. · Revisado há 7 days

Ashish S M. · Revisado há 7 days

dinesh s. · Revisado há 7 days

AKSHAT A. · Revisado há 7 days

Gaurav B. · Revisado há 7 days

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

友紀 芳. · Revisado há 7 days

Piotr Ż. · Revisado há 7 days

Loraine P. · Revisado há 7 days

Seema G. · Revisado há 7 days

Dat L. · Revisado há 8 days

ivan g. · Revisado há 8 days

Marcin K. · Revisado há 8 days

Helene C. · Revisado há 8 days

asdfgdasf

Henrik Brenne F. · Revisado há 8 days

Jouni M. · Revisado há 8 days

Abdulaziz A. · Revisado há 9 days

Naveen K. · Revisado há 9 days

PASUPULETI B. · Revisado há 9 days

good

Rashmi J. · Revisado há 9 days

Viviana Marcela F. · Revisado há 10 days