Thanks for responding so soon. I’ll try giving a sample image in the next two days, till then will try explaining an example here.
Suppose I have 100 remote patients to be covered by field personnel for following up on their health complaints on a monthly basis. The identification for these patients is pre-loaded in the form as choices for a select one question.
When these personnel make their rounds and collect the data, I see an increasing list of the forms for each patient in my data tables over the month.
However, let’s say we are in the last week of the month and I see that I have received only 95 forms. At this point of time, I would very much like to see a section of the report that tells exactly me which patients are remaining to be covered.
What we do currently is download the data, lookup the covered patients from the original list and then filter out the ones left out (may be there is an easier way to do this? I work with Excel)
So can there be a feature that directly executes this query in the KoboToolbox Reports interface itself so that data download isn’t needed until all the expected forms are received.
I hope that gives a clearer idea? You’ll have a sample image from me soon!