Text tables in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

❓ visualization

intermediate

Creating a Basic Text Table

You have sales data with Region and Sales fields. You want to create a text table that shows total sales per region.

Which step is essential to display the total sales correctly in a text table?

A Drag <strong>Region</strong> to Rows and <strong>Sales</strong> to Text on the Marks card.

B Drag <strong>Sales</strong> to Rows and <strong>Region</strong> to Columns.

C Drag <strong>Region</strong> to Filters and <strong>Sales</strong> to Tooltip.

D Drag <strong>Sales</strong> to Color and <strong>Region</strong> to Size.

💡 Hint

Think about how to show categories on rows and numbers as text.

Dragging Region to Rows creates rows for each region. Dragging Sales to Text shows the sales numbers in the table cells.

❓ dax_lod_result

intermediate

Calculating Total Sales per Category

In Tableau, you want to calculate total sales per product category and display it in a text table. Which Tableau calculation will give you the total sales per category regardless of other filters?

Tableau

SUM({FIXED [Category]: SUM([Sales])})

A SUM([Sales])

B SUM({FIXED [Category]: SUM([Sales])})

C WINDOW_SUM(SUM([Sales]))

D TOTAL(SUM([Sales]))

💡 Hint

Look for a calculation that fixes the level of detail to Category.

The FIXED LOD expression calculates total sales per category ignoring other filters, which is useful in text tables to show consistent totals.

🧠 Conceptual

advanced

Understanding Text Table Limitations

Which of the following is a common limitation when using text tables in Tableau for large datasets?

A Text tables can become hard to read and slow to render with many rows and columns.

B Text tables automatically summarize data without user control.

C Text tables cannot display numeric data.

D Text tables do not allow sorting or filtering.

💡 Hint

Think about what happens when you have too much data in a simple table.

Large text tables can be overwhelming visually and may slow down Tableau because many cells must be rendered.

🔧 Formula Fix

advanced

Fixing Incorrect Aggregation in Text Table

You created a text table showing Region and Sales. The sales numbers are showing as individual transaction amounts instead of totals per region.

What is the most likely cause?

A The <strong>Region</strong> field is filtered out.

B The <strong>Sales</strong> field is aggregated with SUM.

C The <strong>Sales</strong> field is not aggregated; it is used as a dimension instead of a measure.

D The text table is sorted by <strong>Region</strong>.

💡 Hint

Check if sales values are summed or shown individually.

If Sales is treated as a dimension (discrete), Tableau shows each value separately instead of summing them.

🎯 Scenario

expert

Designing a Responsive Text Table Dashboard

You need to build a dashboard with a text table showing sales by product and region. The dashboard must be usable on desktop and mobile devices.

Which design practice best ensures readability and usability across devices?

A Show all product and region columns without scrolling and use small fonts to fit all data.

B Use only colors to differentiate data without text labels to save space.

C Use multiple text tables with all details on desktop and hide them on mobile.

D Use a simple text table with limited columns, enable horizontal scrolling, and use clear fonts with good contrast.

💡 Hint

Think about how to keep tables readable on small screens.

Limiting columns, enabling scrolling, and using clear fonts help maintain usability and readability on all devices.

Practice

1. What is the primary purpose of a Text table in Tableau?

easy

A. To visualize data distribution with bars

B. To create interactive maps with geographic data

C. To display exact values in rows and columns for detailed comparison

D. To show trends over time using lines

Solution

1. Step 1: Understand the function of text tables

   Text tables show data in rows and columns with exact values, making detailed comparisons easy.

2. Step 2: Compare with other chart types

   Maps, line charts, and bar charts serve different visualization purposes, not exact value display.

3. Final Answer:

   To display exact values in rows and columns for detailed comparison -> Option C

4. Quick Check:

   Text tables = exact value display [OK]

Hint: Text tables show exact numbers in rows and columns [OK]

Common Mistakes:

• Confusing text tables with charts like bar or line graphs
• Thinking text tables are for geographic data
• Assuming text tables show trends or distributions

2. Which of the following is the correct way to create a text table in Tableau?

easy

A. Drag a measure to Rows and a dimension to Columns

B. Drag dimensions to Rows and Columns, and measures to Text on Marks card

C. Drag measures to Filters and dimensions to Pages

D. Drag dimensions to Filters and measures to Tooltip

Solution

1. Step 1: Identify how to build text tables

   Text tables require dimensions on Rows and Columns, and measures placed on Text in the Marks card to show values.

2. Step 2: Eliminate incorrect options

   Dragging measures to Filters or Tooltip does not create text tables; Filters limit data, Tooltip shows hover info.

3. Final Answer:

   Drag dimensions to Rows and Columns, and measures to Text on Marks card -> Option B

4. Quick Check:

   Dimensions on Rows/Columns + Measures on Text = Text table [OK]

Hint: Put dimensions on Rows/Columns, measures on Text [OK]

Common Mistakes:

• Placing measures on Rows or Columns instead of Text
• Using Filters or Tooltip instead of Text for measures
• Confusing Pages shelf with Rows or Columns

3. Given a Tableau worksheet with 'Category' on Rows, 'Region' on Columns, and 'Sales' on Text, what will the text table display?

medium

A. Sum of Sales for each Category and Region combination

B. Average Sales for each Region only

C. Total Sales for all Categories combined

D. Count of Categories per Region

Solution

1. Step 1: Understand the layout of the text table

   Dimensions 'Category' and 'Region' create rows and columns, so each cell corresponds to a Category-Region pair.

2. Step 2: Interpret the measure on Text

   'Sales' on Text shows the aggregated value (default sum) for each cell's Category and Region combination.

3. Final Answer:

   Sum of Sales for each Category and Region combination -> Option A

4. Quick Check:

   Dimensions define cells, measure shows sum per cell [OK]

Hint: Text shows measure aggregated by row and column dimensions [OK]

Common Mistakes:

• Thinking it shows average instead of sum
• Assuming total sales without breakdown
• Confusing count of categories with sales sum

4. You created a text table but see blank cells where you expected sales values. What is the most likely cause?

medium

A. You dragged the measure to Filters instead of Text

B. You used a continuous field on Rows instead of discrete

C. You placed dimensions on the Tooltip shelf

D. There is no data for those Category and Region combinations

Solution

1. Step 1: Analyze blank cells in text tables

   Blank cells usually mean no data exists for that combination of dimension values.

2. Step 2: Check other options for errors

   Dragging measure to Filters would filter data, not cause blanks in expected cells; Tooltip does not affect layout; continuous fields change axis but don't cause blanks.

3. Final Answer:

   There is no data for those Category and Region combinations -> Option D

4. Quick Check:

   Blank cells = missing data for dimension pairs [OK]

Hint: Blank cells mean no data for those dimension pairs [OK]

Common Mistakes:

• Assuming syntax error causes blanks
• Thinking Tooltip shelf affects cell values
• Confusing continuous vs discrete fields as cause

5. You want to create a text table showing total sales by Category and Region, but also want to highlight sales above $50,000 in red text. How can you achieve this in Tableau?

hard

A. Use a calculated field with IF SUM(Sales) > 50000 THEN 'Red' ELSE 'Black', then place it on Color in Marks card

B. Drag Sales to Filters and set condition sales > 50000

C. Place Category on Tooltip and Region on Detail

D. Use Pages shelf to filter sales above 50000

Solution

1. Step 1: Create a calculated field for color coding

   Write a calculation like IF SUM(Sales) > 50000 THEN 'Red' ELSE 'Black' to assign colors based on sales.

2. Step 2: Apply color to text in the text table

   Place this calculated field on Color in the Marks card to change text color conditionally.

3. Step 3: Verify other options are incorrect

   Filters limit data but don't color text; Tooltip and Pages do not control text color.

4. Final Answer:

   Use a calculated field with IF SUM(Sales) > 50000 THEN 'Red' ELSE 'Black', then place it on Color in Marks card -> Option A

5. Quick Check:

   Conditional color via calculated field + Color shelf [OK]

Hint: Use IF condition in calculated field and put on Color shelf [OK]

Common Mistakes:

• Using Filters instead of color for highlighting
• Placing dimensions on Tooltip instead of Color
• Trying to filter with Pages shelf for color