Use Tableau Continuous Dates to Format Discrete Dates
You’re working on building a new visualization that depicts your organization’s sales per month for the past few years. This visualization has a small section cut out for it on your KPI dashboard, and your hope is to get it to fit in this assigned space. You drag your date field in as a discrete month/year, and then you bring in the sales measure. You work on the chart a bit more and end up with a nice looking bar chart. You then add the chart to your dashboard. The end result is something like the following.
Figure 0.
After staring at your chart for a few minutes, you realize that it would look better and you’d have more room for the visualization if you cut down the size of the date labels. Tableau provides formatting to make dates appear in many different ways, and you want one that looks like “Nov-21.” You return to your sheet, right-click on the pill, and choose the Format option. In the Format window is a date format option, perfect! You click the date format, and are met with disappointment. There is only one option available to you, as shown.
Tableau has two types of fields—discrete and continuous. Discrete fields are chunks of something whereas continuous fields are a range. For example, the Categories field has unique, defined groupings and is discrete; ...
Get Use Tableau Continuous Dates to Format Discrete Dates now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
