Question 3
You need to create the required relationship for the executive's visual. What should you do before you can create the relationship?
Change the data type of Sales[region_id] to Whole Number.
In the Sales table, add a measure for sum(sales_amount).
Change the data type of sales[sales_id] to Text.
Change the data type of sales [region_id] to Decimal Number.
Correct answer: A
Explanation:
Scenario: Executives require a visual that shows sales by region.Need to change the sales_id column from Varchar to Whole Number (Integer).
Scenario: Executives require a visual that shows sales by region.
Need to change the sales_id column from Varchar to Whole Number (Integer).