3.1 Dimensions, Measures, Discrete vs Continuous & Aggregations

3.1 Dimensions, Measures, Discrete vs Continuous & Aggregations

Understanding how Tableau Desktop classifies, organizes, and calculates data is the single most critical foundation for passing the Tableau Desktop Specialist exam. Every visual element in Tableau—from axes and column headers to mark colors and tooltips—is determined by two core attributes of every field in your data source: Data Role (Dimension vs. Measure) and Data Type/Format (Discrete vs. Continuous).

---

Dimensions vs. Measures

When you connect to a data source, Tableau automatically categorizes each field in the Data Pane as either a Dimension or a Measure based on the field's data type.

Dimensions (Qualitative Data)

Dimensions contain qualitative, categorical, or descriptive values. Examples include [Customer Name], [Category], [Region], [Order Date], and [Postal Code].

• Function: Dimensions set the Level of Detail (LoD) in a worksheet. When you drag a dimension into a view (onto Rows, Columns, or Marks shelves), Tableau uses its unique values to group, slice, and slice data into discrete buckets or marks.
• Default Placement: Text, date, geographic, and boolean fields are automatically placed in the Dimensions section of the Data Pane.

Measures (Quantitative Data)

Measures contain quantitative, numerical values that can be measured, aggregated, or mathematically calculated. Examples include [Sales], [Profit], [Quantity], and [Discount].

• Function: Measures generate numerical values that Tableau aggregates when placed in a view. By default, Tableau wraps measures in an aggregate function—most commonly SUM([Field Name]).
• Default Placement: Numerical fields (integers and floating-point decimals) are automatically placed in the Measures section of the Data Pane.

Converting Between Dimensions and Measures

You can easily convert a field between a Dimension and a Measure in Tableau Desktop:

• Method 1: Right-click the field in the Data Pane and select Convert to Dimension or Convert to Measure.
• Method 2: Drag the field across the boundary line between Dimensions and Measures in the Data Pane.

Exam Tip: A numerical field like [Customer ID] or [Order ID] initially imports as a Measure because it contains numbers. However, performing math on customer IDs (like summing them) makes no analytical sense. Converting [Customer ID] to a Dimension allows Tableau to count unique customers and group rows effectively.

---

Discrete vs. Continuous Data (Blue vs. Green)

While Dimension vs. Measure dictates what data does (group vs. aggregate), Discrete vs. Continuous dictates how data is visually displayed on screen. Tableau uses color coding on field capsules (pills) throughout the interface to clearly signal this distinction.

Blue Pills (Discrete)

Discrete fields contain a finite, distinct set of values. When dropped on Rows or Columns, a blue pill creates distinct headers (text labels that break the viz into rows, columns, or panes).

• Dropping [Region] (Blue Dimension) on Columns creates four separate column headers: Central, East, South, West.
• Dropping [Quarter] (Blue Discrete Date) on Rows creates discrete row headers labeled Q1, Q2, Q3, Q4.

Green Pills (Continuous)

Continuous fields contain values on an infinite, continuous numerical scale. When dropped on Rows or Columns, a green pill creates a continuous axis with tick marks and a range of values.

• Dropping SUM([Sales]) (Green Measure) on Rows creates a vertical numerical axis starting at 0 up to the maximum aggregated sales figure.
• Dropping [Order Date] formatted as a Continuous Date (Green) on Columns creates a continuous timeline axis.

Can Dimensions be Continuous? Can Measures be Discrete?

Yes! This is a classic Tableau Desktop Specialist exam question. The concepts are independent:

1. Discrete Dimension (Blue): The default for text/dates (e.g., [Category]). Creates categorical headers.
2. Continuous Dimension (Green): A continuous date field or numeric dimension used for an axis (e.g., continuous [Order Date] or continuous [Age]). Creates an axis without aggregating.
3. Discrete Measure (Blue): A measure that has been converted to discrete (e.g., SUM([Sales]) converted to Discrete). It displays aggregated numerical values as text headers rather than an axis.
4. Continuous Measure (Green): The default for numeric measures (e.g., SUM([Sales])). Creates a continuous numeric axis.

---

Aggregations in Tableau Desktop

When a measure is added to a view, Tableau automatically aggregates its values based on the current level of detail established by dimensions in the view.

Available Default Aggregations

Tableau provides several built-in aggregation functions accessible by right-clicking a measure pill in the view and navigating to Measure (SUM):

• SUM: Adds all values in the partition together (default for numeric fields).
• AVG: Calculates the arithmetic mean of values in the partition.
• MEDIAN: Finds the middle value in a sorted dataset (50th percentile).
• COUNT: Counts the total number of records (rows) including nulls or duplicate entries.
• COUNTD (Count Distinct): Counts only the unique, non-null values in the partition.
• MIN / MAX: Returns the smallest or largest value in the partition.
• PERCENTILE: Returns the value below which a given percentage of observations falls.
• STDEV / STDEVP: Calculates sample or population standard deviation.
• VAR / VARP: Calculates sample or population variance.
• ATTR (Attribute): Returns the field value if all rows in the partition share a single, identical value. If multiple distinct values exist in the partition, ATTR returns an asterisk (*).

Aggregated vs. Disaggregated Data

By default, Tableau aggregates measures across all records in your dataset. However, you can view disaggregated data by navigating to the top menu bar:

• Path: Analysis -> Aggregate Measures (click to toggle checkmark off).
• Result: When Aggregate Measures is unchecked, Tableau turns off aggregation and plots every single individual row from the underlying data source as a separate mark in the view.

---

Summary Comparison Matrix for Exam Review