I'm trying to reconcile the Statistics list against my database and running into some reconciliation issues and wondering if someone could shed some light on what the data in the report should represent.
In the report there are two lines for marriages, "Individuals with marriage event" and "Married Individuals" which give different results:
Individuals with marriage event
2063 total, 1030 male, 1033 female
3159 total, 1578 male, 1581 female
The Married individuals is simply misnamed – it is couples with some type of partnership, not necessarily marriage. The numbers match the distinct males and distinct females in the familyTable, correctly accounting for same sex partnerships.
So now I’m trying to figure out “Individuals with marriage event”
If I look at my data.
I have 1656 families
1237 marriage events. Note: this matches exactly with the “Marriage”
I figured it was easier to start with one gender/sex, so I chose male
of the 1237 marriage events, all of them (1237) have a male (fatherId from familyTable, cross referenced to sex from personTable) associated with them. Since 1237 does not correspond to the 1030 on the statistics report I filtered further
of the 1237 males, several have multiple marriages, so I eliminated these and lowered the count to 1163 distinct males
Then I lower the count by filtering out the marriage events that do not have a date – which I do not believe would be correct, but I am just trying to reconcile the numbers. That left me with 1118 distinct males with a marriage event that is undated.
So no matter how I am looking at this, I cannot come to the number of 1030 males. I may be off on my logic, of course.
Any ideas how the “Individuals with marriage event” is calculated?