9 Replies Latest reply on Aug 14, 2019 8:39 AM by Will Dickinson

# Counting and Grouping Dimension Text  to Create Grouping and Family Makeup / Composition / Head of Household

Trying to use a calculated field to create "Family Composition" for sorting what type of family an individual belongs too.

Example:

1 Self

2 Self / Child

3 Self / Spouse / Child

4 Self / Spouse / Child / Child

etc....

I was able to calculate the family size but not break out the "family composition" groupings ... please advise

This as far I got:

The count of members wasn't correct and not sure this the right approach

• ###### 1. Re: Counting and Grouping Dimension Text  to Create Grouping and Family Makeup

You want subtotals per group? Like this?

• ###### 2. Re: Counting and Grouping Dimension Text  to Create Grouping and Family Makeup

Yes, the hope this get subtotals on each group according these family composition , thanks

• ###### 3. Re: Counting and Grouping Dimension Text  to Create Grouping and Family Makeup / Composition / Head of Household

You are welcome, could you then mark my answer as the correct one so other people know this cased is closed?

Thank you.

• ###### 4. Re: Counting and Grouping Dimension Text  to Create Grouping and Family Makeup

See this graphic above this what I'm going for ..... Grouping by particular composition not just by subgroups of self, child...etc .... the composition of the family needs to defined and counted.

• ###### 5. Re: Counting and Grouping Dimension Text  to Create Grouping and Family Makeup / Composition / Head of Household

The result you seek is then

1. Self 1x

2. Self / Child 1x

3. Self / Spouse / Child 1x

4. Self / Spouse / Child / Child 1x4. Seld / Spouse / Adult Dependent / Child 1x

5. Self / Spouse / Child / Child / Child 1x

5. Self / Child / Child / Child / Child 1x.

But is this the only composition or you want to take all varables into account incase future/other families have different compositions.

1 of 1 people found this helpful
• ###### 6. Re: Counting and Grouping Dimension Text  to Create Grouping and Family Makeup

Yes, it would be helpful to have all variations but at least the top 10 variations defined and then the other could be grouped as "other"

1. Self 1x

2. Self / Child 1x

3. Self / Spouse / Child 1x

4. Self / Spouse / Child / Child 1x4. Seld / Spouse / Adult Dependent / Child 1x

5. Self / Spouse / Child / Child / Child 1x

5. Self / Child / Child / Child / Child 1x.

I would rather define on type not count, but count included in definition

1. 1 Self

2. 2 Self / Child

3. 2 Self / Spouse

4. 3 Self / Spouse / Child

5. 3 Self / Child / Child

....etc

Other

1 of 1 people found this helpful
• ###### 7. Re: Counting and Grouping Dimension Text  to Create Grouping and Family Makeup / Composition / Head of Household

I solved this by fixing the "ID Family" and "FamilySizeGroups" ! Very happy with results

Tableau Public

Use the following calculated field to create the groupings by dimension

1 of 1 people found this helpful
• ###### 8. Re: Counting and Grouping Dimension Text  to Create Grouping and Family Makeup / Composition / Head of Household

Very ingenious way to solve this issue.

I was unable to find the solution.