Grouping members in Tableau - Practice Problems & Coding Challenges

Challenge - 5 Problems

🧠 Conceptual

intermediate

Understanding Tableau Grouping Behavior

In Tableau, when you create a group of members from a dimension, what happens to the grouped members in the view?

A They are combined into a single new member with a new group name.

B They remain as separate members but are highlighted together.

C They are filtered out from the view and hidden.

D They are duplicated in the view with the original names.

💡 Hint

Think about how grouping simplifies the dimension members in the view.

Grouping in Tableau combines selected members into one new member with a group name, simplifying analysis.

❓ dax_lod_result

intermediate

Result of Grouping Members in Tableau

Suppose you have a dimension 'Product Category' with members 'Furniture', 'Office Supplies', and 'Technology'. You group 'Furniture' and 'Office Supplies' into a group named 'Non-Tech'. What will be the members visible in the view after grouping?

A Furniture, Office Supplies, Technology

B Non-Tech only

C Non-Tech, Technology

D Furniture, Office Supplies only

💡 Hint

Grouping merges selected members into one group and leaves others unchanged.

After grouping 'Furniture' and 'Office Supplies' into 'Non-Tech', the view shows 'Non-Tech' and the ungrouped 'Technology'.

❓ visualization

advanced

Best Visualization for Grouped Members

You have grouped several customer segments into three groups in Tableau. Which visualization type best shows the sales distribution across these groups clearly and accessibly?

A Line chart showing sales over time for each group

B Pie chart showing percentage sales per group with clear labels

C Scatter plot with groups as color-coded points

D Stacked bar chart with each group as a separate bar segment

💡 Hint

Consider clarity and ease of comparing parts of a whole.

A pie chart with clear labels effectively shows the proportion of sales per group, making it easy to compare group sizes.

🔧 Formula Fix

advanced

Troubleshooting Grouping Issues in Tableau

You created a group in Tableau but notice that some members you grouped still appear separately in the view. What is the most likely cause?

A The group was created but the original dimension was not replaced in the view.

B You did not apply the group to the worksheet after creating it.

C You grouped members from a different dimension than the one used in the view.

D Tableau does not support grouping for that data type.

💡 Hint

Think about how Tableau uses groups in the view.

Groups must replace the original dimension in the view to show grouped members combined; otherwise, original members appear separately.

🎯 Scenario

expert

Scenario: Dynamic Grouping for Sales Analysis

You want to create a dynamic group in Tableau that automatically groups products with sales below a threshold into 'Low Sales' and others remain as their original names. Which approach achieves this?

A Create a set with low sales products and use it as a filter.

B Manually group low sales products and update the group regularly.

C Use a parameter to select products and group them manually.

D Create a calculated field using IF statement to assign 'Low Sales' or product name, then use it as a dimension.

💡 Hint

Think about automating grouping based on data values.

A calculated field with an IF statement dynamically assigns group names based on sales, updating automatically as data changes.