-
1. Re: Counting and Grouping Dimension Text to Create Grouping and Family Makeup
sander.binda Jul 12, 2019 12:13 AM (in response to Will Dickinson)You want subtotals per group? Like this?
-
Family_Relationships.twbx 22.6 KB
-
-
2. Re: Counting and Grouping Dimension Text to Create Grouping and Family Makeup
Will Dickinson Jul 13, 2019 2:55 PM (in response to sander.binda)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
sander.binda Jul 14, 2019 11:48 PM (in response to Will Dickinson)You are welcome, could you then mark my answer as the correct one so other people know this cased is closed?
Thank you.
-
5. Re: Counting and Grouping Dimension Text to Create Grouping and Family Makeup / Composition / Head of Household
sander.binda Jul 15, 2019 6:59 AM (in response to Will Dickinson)1 of 1 people found this helpfulThe 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.
-
6. Re: Counting and Grouping Dimension Text to Create Grouping and Family Makeup
Will Dickinson Jul 15, 2019 9:12 AM (in response to sander.binda)1 of 1 people found this helpfulYes, 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
-
7. Re: Counting and Grouping Dimension Text to Create Grouping and Family Makeup / Composition / Head of Household
Will Dickinson Aug 13, 2019 9:46 PM (in response to Will Dickinson)1 of 1 people found this helpfulI solved this by fixing the "ID Family" and "FamilySizeGroups" ! Very happy with results
Use the following calculated field to create the groupings by dimension
-
8. Re: Counting and Grouping Dimension Text to Create Grouping and Family Makeup / Composition / Head of Household
sander.binda Aug 13, 2019 11:23 PM (in response to Will Dickinson)1 of 1 people found this helpfulVery ingenious way to solve this issue.
I was unable to find the solution.
Could you mark your own answer as the correct one (bottom left corner of your post)
Then everyone knows the issue is solved.
Thank you.
-
9. Re: Counting and Grouping Dimension Text to Create Grouping and Family Makeup / Composition / Head of Household
Will Dickinson Aug 14, 2019 8:39 AM (in response to sander.binda)Thank you for your help!