i wanted to find only duplicate records in the report and duplicate records count
Can you some give an idea how to achieve that in tableau
You can use following formula to get the duplicated vs distinct records:
IF COUNT([Id]) >= 2
Retrieving data ...