What should you do first?

You have a table named Sales. A sample of the data in Sales is shown in the following table.

You create a stacked column chart visualization mat displays Product Name by Date.

You discover that the axis for the visualization displays all the individual dates.

You need to ensure that the visualization displays Product Name by year and that you can drill down to see Product Name by week and day.

What should you do first?
A . Configure a visual filter for the Date column that uses an advanced fitter.
B . Create a new table that has columns for the date. year, week, and day.
C . Create a new hierarchy in the Sales table.
D . Format the visualization and set the type of the X-Axis to Categorical.

View Answer

Answer: B