Filtering data by unique values

Question & Answer
, ,
1

Hi,

I have data containing different trades and this trades have a trade id field.

Some trade ids appear only once and are unique but sometimes i can have different trades with the same trade id.

I’m trying to build a filter based on the trade id to visualize the trades that are unique or only the trades that are not unique.

I have tried using

image
image720×273 4.11 KB

but I don’t think this is the correct formula as i thinks count just counts the total number of ids 7

Can any one suggest a solution?

Thank you in advance,

Domenico

2

Hi @Dom
did you try out your formula?

“Count” counts every entry for each t_customer_reference (in my sample “store_id”)

grafik
grafik711×355 26.2 KB

store_id 11 appears 8264 times in my data.

BR

1 Like
3

Hi @Dom
any updates on your side?
BR

4

Hi there, ive got a similar query. ive got a list of ID which shouldnt have Duplicates.

Id like to be able to create a filter from a calculated field to look up the data and if Unique call it such with the second of any ID 2 and above.
Allowing me to just filter out dupes from existing tables.