Unique Filter

Question & Answer
,
1

Hi there,
Ive got a list of lead ids in my data which shouldnt have Duplicates, but they crop up sometimes - 10ish monthly

Id like to be able to create a filter from a calculated field to look up the data and if Unique call it such with the second of any ID 2 and above.
Allowing me to just filter out dupes from existing tables.
Ideally a count - so the first of these ids would be 1 if there are 2 then 2 - so on.

Any help would be appreciated.

thanks
Alan

2

Hi @alan.lawlor ,

If I understand your requirement you want to do a running count of the id based on some sorting criteria. You can use runningCount for this case, with the ordering criteria defined.

You can then use the same field to filter.

Thanks,
Prantika