Incorrect 90th Percentile Calculation Due to Duplicated Rows

[duncan]

Hello @Purushothaman

The main issue here is deduplicating the rows. I would recommend creating a calculation on the dataset layer to mark duplicate vs original rows and then filtering the data on the dataset layer.

Here’s an example:

Remove duplicate rows from dataset

Hello @egobbo . You can also create calculated fields at the dataset level and then create a filter at the dataset level as well. This way you can filter the data directly there and make sure that all the analyses that use it received the filtered data. However remember that it is the best practice to work with already clean and massaged datasets to avoid overloading the BI layer with calculations and filters so your visuals can render blazing fast. I would recommend to create a data pipelin…