Skip to Content
0
Jun 05, 2020 at 05:53 PM

How to get distinct count when there are duplicate records.

44 Views

I need a solution on how to get the correctly.

1. I am generating a report on total number of Arrests by gender.

2. The fields I have chosen are Case number, Date of Arrest, Name, Gender, and Offense. And grouped by Gender.

3. I am trying to get a total for how many total arrests there were for each Gender.

I can't do a distinct count by case number because sometimes there are multiple people arrested per case number. I can't do a distinct count on Name, because sometimes people are arrested more than once.

Looking for a solution to get the most accurate count of Arrests by gender.