It would be difficult to comment without looking at a data. You need to first confirm that each row in your data set is unique or joining conditions are not causing the duplication of rows.
Thanks for the reply!
As you can see from the screenshot, each incident is repeated twice. I'm not using any join conditions here as it is a data coming from one single table.
Dataset has some duplicated rows. But when we aggregate in Tableau, it shows only unique records showing count as 122, but when i try to view underlying data, it shows something around 300 records. Why is this happening?
by default tableau remove duplicates in a view.
1. All Dimensions - In order to reveal all records you can use calculated field =index() and use it in your view.
2. Dimension & Measures - Go to Analysis --> Uncheck Aggregate Measures
You can create a calculation that divides the sum of the field being duplicated by the number of instances of the field that is causing the duplication.
For more information please refer to the "Troubleshoot joins" article below.
Another possible way to remove duplicate data that may result after joining tables, is to use a FIXED expression as documented in the knowledge base article below.
Hope this help.