Câu 37: Certified Tableau CRM and Einstein Discovery Consultant
Universal Containers has a dashboard for Sales Managers to visualize the YoY Growth of their customers. The formula used is: YoY = [(This Year - Last Year) /Last Year] %Based on the graphic, when there is no account in the Last Year column, the YoY Growth shows null results. The Sales Managers want to replace it with…
Nội dung câu hỏi
Universal Containers has a dashboard for Sales Managers to visualize the YoY Growth of their customers. The formula used is: YoY = [(This Year - Last Year) /Last Year] %Based on the graphic, when there is no account in the Last Year column, the YoY Growth shows null results. The Sales Managers want to replace it with 100% value. What is the correct function to use?
Các lựa chọn
Đáp án được giữ gọn theo nhãn A, B, C, D trong phần bình chọn tương tác.
- A. coalesce() — đáp án hiện tại
- B. number_to_string()
- C. substr()
- D. replace()
Cộng đồng
0 bình luận công khai. Tên thành viên được ẩn một phần.