We would like a pre-calculated field in Looker that shows a count of the CURRENT enrollment household. The only existing fields now show a static count at the time of entry but that can change as household members get exited or new ones enter.

additional context in support ticket: 38906463297