What should you do?

You have the following chart that shows the cumulative of sales from various dates.

You want the months to appear as shown in the following chart.

What should you do?
A . Convert the date to Exact Date
B . Convert the date to Continuous
C . Select Show Misting Values for the dale
D . Convert the date to Attribute

View Answer

Answer: A

Explanation:

To make the months appear as shown in the second chart, you need to convert the date to Continuous. A continuous date is a green pill that shows a range of values on an axis. A discrete date is a blue pill that shows individual values as headers. In this case, you want to show a continuous range of months on the x-axis, instead of discrete headers.

To convert the date to Continuous, you need to do the following steps: Right-click on the date field on the Columns shelf and select Convert to Continuous from the menu. This will change the date pill from blue to green and show a continuous range of dates on the x-axis. Right-click on the date field again and select Month (January 2017) from the menu. This will change the level of detail of the date to month and year, instead of day.

Optionally, you can format the date axis by right-clicking on it and selecting Format from the menu.

You can change the scale, tick marks, labels, and other options.

The other options are not correct for this scenario. Converting the date to Exact Date will show every single date as a header, which will be too crowded and unreadable. Selecting Show Missing Values for the date will fill in any gaps in the data with null values, but it will not change how the months appear. Converting the date to Attribute will return only one value for each partition of data, which will not show any variation over time.

Reference:

https://help.tableau.com/current/pro/desktop/en-us/dates.htm

https://help.tableau.com/current/pro/desktop/en-us/dates_continuous.htm

https://help.tableau.com/current/pro/desktop/en-us/formatting.htm