Count duplicate users with Search for

Looking for a way with Search For to identify users from this table who have attended >1 event
image

Only User C attended Event 1 and 2. So the result I’m looking for should be 1.

I need count users who have >1 event but haven’t figured out a way to do so.

Any suggestions?

1 Like

How is your data set up?

Hi. It looks like the above table. It has a natural compound primary key so I cannot do a simple count > 1 which only looks at a single field.

Hmm. Perhaps you will need a new table to track that.

This topic was automatically closed after 70 days. New replies are no longer allowed.