Continuous vs discrete dates in Tableau - Practice Questions

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Continuous vs Discrete Dates in Tableau

In Tableau, dates can be treated as continuous or discrete. Which statement correctly describes the difference between continuous and discrete dates?

A Discrete dates create a green pill and show a timeline with all dates in a range, while continuous dates create a blue pill and show distinct date parts as separate headers.

B Continuous dates create a green pill and show a timeline with all dates in a range, while discrete dates create a blue pill and show distinct date parts as separate headers.

C Continuous dates and discrete dates both create blue pills but differ in sorting order only.

D Discrete dates create a green pill and continuous dates create a blue pill, but both display dates as a list without timeline.

💡 Hint

Think about the color of the pill and how Tableau displays dates on the axis.

Continuous dates in Tableau are shown as green pills and create a continuous timeline axis, including all dates in the range. Discrete dates are blue pills and show distinct date parts as headers or labels.

❓ visualization

intermediate

Visualizing Sales Over Time with Continuous Dates

You want to create a line chart showing total sales over time with a smooth timeline including every date. Which date type should you use on the Columns shelf in Tableau?

A Use a continuous date (green pill) like Exact Date to show sales on a continuous timeline.

B Use a discrete date (blue pill) like YEAR(Date) to show sales by year as separate columns.

C Use a string representation of the date to sort sales alphabetically.

D Use a discrete date (blue pill) like MONTH(Date) to show sales by month as separate headers.

💡 Hint

Think about which date type creates a smooth timeline axis for line charts.

Continuous dates (green pills) create a continuous timeline axis, ideal for line charts showing trends over time. Discrete dates create headers or labels, which break the timeline into parts.

❓ dax_lod_result

advanced

Calculating Sales by Discrete Year vs Continuous Date

Given a sales table with a Date column, which DAX measure correctly calculates total sales by discrete year (not continuous timeline)?

Sales by Year = CALCULATE(SUM(Sales[Amount]), YEAR(Sales[Date]))

Which option correctly replaces the YEAR(Sales[Date]) part to work as a discrete year grouping?

A FILTER(Sales, YEAR(Sales[Date]) = YEAR(TODAY()))

B ALL(Sales[Date])

C DISTINCT(Sales[Date])

D VALUES(YEAR(Sales[Date]))

💡 Hint

Think about how to get distinct year values for grouping in DAX.

VALUES(YEAR(Sales[Date])) returns the distinct years from the Date column, which is needed for discrete year grouping. Other options do not provide distinct year values for grouping.

🔧 Formula Fix

advanced

Fixing a Tableau Date Axis Showing Unexpected Gaps

You created a line chart with a continuous date axis in Tableau, but the timeline shows unexpected gaps where no data exists. Which option best explains why this happens?

A The date field is continuous, but the data source has missing dates, so Tableau shows gaps in the timeline.

B The date field is discrete, and Tableau automatically fills missing dates with nulls, so gaps appear.

C The date field is continuous, and Tableau fills missing dates with zeros, so no gaps should appear.

D The date field is discrete, so Tableau only shows dates with data, causing gaps.

💡 Hint

Think about how continuous axes handle missing data points.

Continuous date axes show all dates in the range, but if the data source lacks records for some dates, Tableau shows gaps. Discrete dates only show existing dates, so no gaps appear.

🎯 Scenario

expert

Choosing Date Type for a Sales Dashboard with Mixed Granularity

You are building a sales dashboard in Tableau that shows monthly sales trends and allows users to drill down to daily sales. Which approach best uses continuous and discrete dates to achieve this?

A Use discrete MONTH(Date) pills for the main trend and continuous DAY(Date) pills for drill down to show a smooth daily timeline.

B Use discrete YEAR(Date) pills for the main trend and continuous MONTH(Date) pills for drill down to show a smooth monthly timeline.

C Use a continuous MONTH(Date) pill for the main trend and discrete DAY(Date) pills for drill down to show exact days as headers.

D Use continuous YEAR(Date) pills for the main trend and discrete MONTH(Date) pills for drill down to show months as headers.

💡 Hint

Consider which date type creates smooth timelines and which creates headers for drill down.

Continuous dates create smooth timelines ideal for main trends. Discrete dates create headers or labels, useful for drill down views showing exact date parts.