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.