Statistical summary card in Tableau - Cheat Sheet & Quick Revision

Recall & Review

beginner

What is a Statistical Summary Card in Tableau?

A Statistical Summary Card in Tableau is a visual element that shows key statistics like average, median, minimum, maximum, and count for a selected data field. It helps quickly understand data distribution.

beginner

Which Tableau feature helps create a Statistical Summary Card?

You can use Tableau's built-in Summary Card or create calculated fields with aggregation functions like AVG(), MIN(), MAX(), and then display them in a dashboard as text or KPI cards.

intermediate

How do you calculate the median in Tableau for a Statistical Summary Card?

Tableau has a MEDIAN() aggregation function for numeric fields, and you can also create a calculated field using WINDOW_MEDIAN() for more complex cases.

beginner

Why is it important to include count and distinct count in a Statistical Summary Card?

Count shows how many data points exist, while distinct count shows how many unique values are present. Both help understand data size and uniqueness, which is important for data quality and analysis.

beginner

What is a best practice when designing a Statistical Summary Card in Tableau dashboards?

Use clear labels, consistent number formatting, and avoid clutter. Show only the most relevant statistics to keep the card simple and easy to read at a glance.

Which aggregation function in Tableau gives the average value of a field?

A MIN()

B SUM()

C COUNT()

D AVG()

AVG() calculates the average (mean) of the selected numeric field.

What does the COUNTD() function in Tableau return?

A Total number of records

B Number of unique values

C Sum of values

D Median value

COUNTD() returns the count of distinct (unique) values in a field.

Which Tableau function can be used to find the median in a window of data?

A WINDOW_MEDIAN()

B MEDIAN()

C AVG()

D SUM()

WINDOW_MEDIAN() calculates the median over a specified window of data.

What is a key benefit of using a Statistical Summary Card in a dashboard?

A Provides quick insights into data distribution

B Replaces all charts

C Shows detailed raw data

D Filters data automatically

Statistical Summary Cards provide quick, easy-to-understand insights about data statistics.

Which of these is NOT typically shown on a Statistical Summary Card?

A Minimum value

B Maximum value

C Data source connection details

D Average value

Data source connection details are not part of statistical summaries.

Explain how you would create a Statistical Summary Card in Tableau for sales data.

Think about what numbers help understand sales quickly.

Why is it useful to include both count and distinct count in a Statistical Summary Card?

Consider how many data points and how many unique items exist.