2 Replies Latest reply on Jul 20, 2016 9:48 AM by Simon Runc

# Duplicates Filters and labels

Dear Community,

Currently I have a series of observations plotted against time (worksheet 1). Every point may contain one or more elements. I am interested in points than contain more than one element because that would mean I have a duplicate for that specific time point in that particular ID.

I plotted IDs vs time and filtered data using a calculation filter with the following formula: IF (COUNT([Número de registros]))>1 THEN "MOSTRAR" ELSE "NO MOSTRAR" END. With the resulting view, I am able to view number of duplicates if I click on each ID label.

For example, ID #28347 shows three points that contain 7 elements in total. Ideally, I would like to have a bar chart plotting IDs vs number of duplicates. However, if not possible I would like to show the number of duplicates (7 elements) in the view and maybe sort the view according to this number in a descending order.

In a second workbook, I managed to obtain the number of duplicates by replicating the first workbook using a text table and grand totals. Still, it is not what I am looking for as an end result.

Thank you very much in advance.

• ###### 1. Re: Duplicates Filters and labels

Hi Sandra,

You'll need to upload a Tableau Packaged Workbook based on your real data or sample data to replicate the scenario.

• ###### 2. Re: Duplicates Filters and labels

hi Sandra,

Thanks for posting a workbook...make finding you a solution much easier!

So the issue you have here is that you SUM([Number of Records]) > 1 check is an aggregate calculation so only works when you have both Time and ID in you VizLoD...you may find this post helpful Answer - Quora

To get round this we can use FIXED LoD expression, so we calculate the SUM([number of records]) at the Time/ID level, and then we can use this field in the Viz.

So I created the following calculation

[Duplicate Count]

IF {FIXED [Mtc],[Fechahora]: SUM([Number of Records])} > 1 THEN 1 ELSE 0 END

I then bring this into the Viz as a SUM and (I think!) we get the result you want.

Hope this solves your issue and makes sense, but if not please post back

1 of 1 people found this helpful