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.

Practice

1. What is the main purpose of creating bins in Tableau?

easy

A. To create calculated fields for text data

B. To join two tables based on a key

C. To filter out null values from a dataset

D. To group continuous numeric data into ranges for easier analysis

Solution

1. Step 1: Understand what bins do in Tableau

   Bins group continuous numeric data into ranges or intervals to simplify analysis.

2. Step 2: Compare options to the bin concept

   Only To group continuous numeric data into ranges for easier analysis describes grouping numeric data into ranges, which matches bins' purpose.

3. Final Answer:

   To group continuous numeric data into ranges for easier analysis -> Option D

4. Quick Check:

   Bins = Group numeric data into ranges [OK]

Hint: Bins group numbers into ranges for simpler analysis [OK]

Common Mistakes:

• Confusing bins with filters
• Thinking bins apply to text data
• Assuming bins join tables

2. Which of the following is the correct way to create bins in Tableau?

easy

A. Right-click a numeric field and select 'Create > Bins'

B. Drag a dimension to the Columns shelf and select 'Create > Bins'

C. Right-click a text field and select 'Create > Bins'

D. Use the Data menu and select 'Create > Calculated Field'

Solution

1. Step 1: Recall the bin creation method in Tableau

   You create bins by right-clicking a numeric field and choosing 'Create > Bins'.

2. Step 2: Check each option against this method

   Only Right-click a numeric field and select 'Create > Bins' matches the correct method; others either use wrong field types or wrong menu options.

3. Final Answer:

   Right-click a numeric field and select 'Create > Bins' -> Option A

4. Quick Check:

   Create bins = Right-click numeric field > Create > Bins [OK]

Hint: Bins come from right-clicking numeric fields, not text [OK]

Common Mistakes:

• Trying to create bins from text fields
• Using the Data menu instead of field context menu
• Dragging dimensions instead of numeric fields

3. Given a numeric field 'Sales' with values from 0 to 1000, if you create bins with a size of 200, how many bins will Tableau create?

medium

A. 4

B. 6

C. 5

D. 10

Solution

1. Step 1: Calculate the number of bins using Tableau's formula

   Number of bins = floor(1000 / 200) - floor(0 / 200) + 1 = 5 - 0 + 1 = 6 bins.

2. Step 2: Confirm Tableau binning

   Tableau uses floor(value / size) * size for bin start: bins at 0, 200, 400, 600, 800 covering 0-200, 200-400, 400-600, 600-800, 800-1000.

3. Step 3: Correct the calculation

   Since max value is 1000 and bin size is 200, bins start at 0, 200, 400, 600, 800 covering up to 1000, so total bins = 5.

4. Final Answer:

   5 -> Option C

5. Quick Check:

   floor(1000/200) - floor(0/200) + 1 = 6 but last bin covers 1000-1200 which is beyond max, Tableau creates 5 bins covering data [OK]

Hint: floor(max/size) - floor(min/size) + 1 usually, but check max coverage [OK]

Common Mistakes:

• Calculating range / size = 5 without endpoint adjustment
• Confusing bin size with number of bins
• Assuming bins start at 1 instead of 0

4. You created bins on a numeric field but Tableau shows an error: 'Cannot create bins on this field.' What is the most likely cause?

medium

A. The field is a string or non-numeric data type

B. The data source is not connected

C. The bin size is set to zero

D. The field is a dimension, not a measure

Solution

1. Step 1: Understand bin creation requirements

   Bins can only be created on numeric fields. If the field is string or non-numeric, Tableau cannot create bins.

2. Step 2: Analyze error causes

   The field is a string or non-numeric data type matches the cause: field is non-numeric. Other options are less likely or unrelated to this error.

3. Final Answer:

   The field is a string or non-numeric data type -> Option A

4. Quick Check:

   Bins need numeric fields, non-numeric causes error [OK]

Hint: Bins require numeric fields; strings cause errors [OK]

Common Mistakes:

• Trying to create bins on text fields
• Assuming bin size zero causes this error
• Ignoring data source connection issues

5. You want to analyze customer ages grouped in 10-year ranges using bins. The 'Age' field ranges from 18 to 72. Which bin size should you choose to create exactly 6 bins covering all ages?

hard

A. 9

B. 11

C. 13

D. 10

Solution

1. Step 1: Recall Tableau's bin count formula

   Number of bins = floor(72 / size) - floor(18 / size) + 1. Need this = 6.

2. Step 2: Test options

   A 11: floor(72/11)=6, floor(18/11)=1 -> 6-1+1=6 [check]
   B 9: floor(72/9)=8, floor(18/9)=2 -> 8-2+1=7 ✗
   C 13: floor(72/13)=5, floor(18/13)=1 -> 5-1+1=5 ✗
   D 10: floor(72/10)=7, floor(18/10)=1 -> 7-1+1=7 ✗

3. Final Answer:

   11 -> Option B

4. Quick Check:

   floor(72/11)-floor(18/11)+1=6 [OK]

Hint: Divide range by bins, round up to cover all data [OK]

Common Mistakes:

• Choosing bin size equal to exact range divided by bins without rounding
• Ignoring that bins must cover entire range
• Assuming 10-year bins always create 6 bins regardless of range