Report to find duplicates

[Jeremy18]

I need help building a report to find duplicative web form submissions. We are rejecting true duplicates for the same date, but submitters get around this by falsifying dates. There are 6 fields including Account, Product, and Lot Number which need to be compared against other cases. The goal is to look for cases created within the past 7 days where the values in these fields match the values entered on other cases. The oob report logic for "is same as" doesn't work here because it compares values on the same record rather than comparing against the values entered on other records.

[Aniket Chavan]

Hello @Jeremy18 ,

Please refer the community posts below and let me know your views on this.

1. Report - show duplicates
2. Filtering a table or report based on the count of records in a grouping 

Let me know your views on this and Mark ✅Correct if this solves your query and also mark 👍Helpful if you find my response worthy based on the impact.

Regards,

Aniket

[Dr Atul G- LNG]

Hi @Jeremy18 

links provided by @Aniket Chavan is good to go, even i was thinking to add the same but he did before me.

Thanks @Aniket Chavan 

[Jeremy18]

Neither of those meet the need. The report needs to show where created is within the past 7 days and Case X matches on ALL 6 variables with any other case. See screenshot for concept.

[Aniket Chavan]

Hello @Jeremy18 ,

Those links were just for the reference not the exact same requirement, so you need to refer and make the changes in configurations as per your business requirement.

Let me know your views on this.