关于“使用 LookML 创建测量和维度”的评价

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. · 已于 6 days前审核

Krystian Ł. · 已于 6 days前审核

Marc B. · 已于 6 days前审核

Ivonne C. · 已于 6 days前审核

Anandakumar V. · 已于 6 days前审核

Yunfei B. · 已于 7 days前审核

Ashish S M. · 已于 7 days前审核

dinesh s. · 已于 7 days前审核

AKSHAT A. · 已于 7 days前审核

Gaurav B. · 已于 7 days前审核

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

友紀 芳. · 已于 7 days前审核

Piotr Ż. · 已于 7 days前审核

Loraine P. · 已于 7 days前审核

Seema G. · 已于 7 days前审核

Dat L. · 已于 8 days前审核

ivan g. · 已于 8 days前审核

Marcin K. · 已于 8 days前审核

Helene C. · 已于 8 days前审核

asdfgdasf

Henrik Brenne F. · 已于 8 days前审核

Jouni M. · 已于 8 days前审核

Abdulaziz A. · 已于 9 days前审核

Naveen K. · 已于 9 days前审核

PASUPULETI B. · 已于 9 days前审核

good

Rashmi J. · 已于 9 days前审核

Viviana Marcela F. · 已于 10 days前审核