How can one filter for duplicate records using the browser- Survey123 data display? I've got some duplicate records submitted under the same Sample ID. I tried to filter using the Sample ID field and identify the records that are not unique. It won't let me add the expression. I've also tried querying in the inbox of the field application but my where expressions are not displaying any records, even if I use the syntax Sample_ID = 'xxx' it won't return that specific record. Any ideas on better ways to filter submitted survey data based on fields in Survey123?
If you ar trying to filter to a specific Sample ID, you should be able to do so via the filter capabilities in the Data tab. If you are trying to identify all Sample IDs that have more than one record, you may want to use the Analysis tab - the chart for the sample ID field should be able to identify that.