...
- district_id
- health_center_id
- mnch_services_available
and you have a multiple choice lookup table question with the filter:hidden value that contains the calculation:
- count(instance('health_centers_by_region')/health_centers_by_region_list/health_centers_by_region[mnch_services_available="yes"][district_id = /data/district_id])
If this table is large enough that this filter is slowing down performance in your form, you may be able to alleviate this by adding an index to district_id and moving the indexed field to the front of your filter, like soso that:
- [mnch_services_available="yes"][district_id = /data/district_id]
becomes:
- [district_id = /data/district_id][mnch_services_available="yes"]
...