Creating bins in Tableau - Practice Exercises

Challenge - 5 Problems

❓ dax_lod_result

intermediate

Calculate the number of bins created for Sales Amount

You create bins in Tableau for the field Sales Amount with a bin size of 1000. The sales data ranges from 500 to 9500.

How many bins will Tableau create?

A 11

B 8

C 9

D 10

💡 Hint

Tableau bins use floor(value / bin_size) * bin_size. Count from floor(500/1000)*1000 to floor(9500/1000)*1000.

The range is from 500 to 9500. Bins start at 0 (0-999), 1000, 2000, ..., 9000 (9000-9999), totaling 10 bins. Formula: FLOOR(9500/1000) - FLOOR(500/1000) + 1 = 9 - 0 + 1 = 10.

❓ visualization

intermediate

Identify the correct bin visualization

You create bins for Customer Age with a bin size of 5 years. Which visualization best shows the distribution of customers by these age bins?

A A bar chart with age bins on the x-axis and count of customers on the y-axis

B A pie chart showing total sales by age bins

C A line chart with continuous age on the x-axis and sales on the y-axis

D A scatter plot of age vs. sales amount

💡 Hint

Bins group data into categories. Which chart type best shows counts per category?

A bar chart with bins on the x-axis and counts on the y-axis clearly shows how many customers fall into each age group. Pie charts or scatter plots do not effectively show counts by bins.

❓ data_modeling

advanced

Choosing bin size for balanced distribution

You have sales data with amounts ranging from 0 to 100,000. You want to create bins that produce roughly equal numbers of sales in each bin.

Which approach is best?

A Create bins based on percentiles (quantile bins)

B Create bins using the average sales amount as bin size

C Create fixed-size bins of 10,000 each

D Create bins manually by splitting the range into 5 equal parts

💡 Hint

Think about how to get equal counts in each bin, not equal ranges.

Percentile or quantile bins divide data so each bin has roughly the same number of records. Fixed-size bins or equal range splits may produce uneven counts if data is skewed.

🔧 Formula Fix

advanced

Why does the bin field show unexpected nulls?

You created a bin field for Order Quantity in Tableau, but some rows show null in the bin field.

What is the most likely cause?

A The bin size is set to zero, causing invalid bin calculation

B The original field contains null or non-numeric values

C The bin field was created on a calculated field instead of a raw field

D The data source connection is broken

💡 Hint

Bins require numeric values. What happens if data has missing or text values?

If the original field has null or non-numeric values, Tableau cannot assign those rows to bins, resulting in nulls in the bin field.

🧠 Conceptual

expert

Impact of binning on aggregation and filtering

In Tableau, you create bins on Sales Amount and use the bin field in a view with aggregated SUM(Sales). You then apply a filter on the bin field.

What is the impact of filtering on bins before aggregation?

A Bins cannot be used as filters in Tableau

B Filtering on bins happens after aggregation, so SUM(Sales) includes all sales regardless of bin filter

C Filtering on bins limits the data before aggregation, so SUM(Sales) only includes sales in selected bins

D Filtering on bins causes Tableau to recalculate bins dynamically for filtered data

💡 Hint

Think about the order of operations: filtering vs aggregation.

Filters on bins restrict the data rows before aggregation. Thus, SUM(Sales) only sums sales in the filtered bins.