Remove duplicate rows from dataset

Thanks for the reply, but I have already tried your idea without luck. I don’t need a filter on the dashboard, I need less data in the dataset.

Let me be more detailed. I create a calculate fields like this

vibrationMaxValue = maxOver({l3dspmaxvalue},[{t042}],PRE_FILTER)

In this way vibrationMaxValue will have a max value within t042 parition. This is right, but I need to exclude all duplicated values and I don’t know how to create. I tryied to change that field in

vibrationMaxValue = maxOver({l3dspmaxvalue},[{t042}, {is_duplicated_t040}],PRE_FILTER)

but it give me an error. All I want is to exclude duplicated values…

Thanks
Enrico

1 Like