How to dynamically determine and categorize duplicate value in Tableau

0 votes

Sample Dataset:

ID | Date | DollarAmount
 1 | Jan  |    50
 1 | Jan  |    20
 2 | Jan  |    10
 1 | Feb  |    20
 2 | Feb  |    10

Goal: Dynamically determine if a particular period in time has a duplicate value based on the ID column.

Sample Graph to be created:

enter image description here

What I already tried: I tried adding filter based on Number of Records but it filtered based on the TOTAL observations across the data-set, not date ranges.

Apr 13, 2018 in Tableau by Atul
• 10,240 points
7,207 views

1 answer to this question.

0 votes

Apparently you define a duplicate records as those that have the same value for the ID and Date fields, where Date is really a string containing the abbreviation for the month name.

In that case, define a (Boolean valued) LOD calculated field called [Duplicates] as {FIXED [ID], [Date] : Count(1) > 1}

Add [Duplicates] on the color shelf, Sum([Dollar Amount]) on rows and [Date] on the Columns.

You will find the True and False values on the Color Legend. If you want you can edit the aliases for those more clear label such as Duplicates and Non-Duplicates

If you have a true date valued field instead of a string, you can even use DateTrunc() function to define the duplicate test at the granular level.

answered Apr 13, 2018 by xyz
• 1,560 points

Related Questions In Tableau

0 votes
1 answer

How to count occurrence of value and percentage of a subset in tableau public?

Although it sounds like a fairly easy ...READ MORE

answered Jun 5, 2018 in Tableau by Atul
• 10,240 points
11,664 views
0 votes
1 answer

How to merge Year ,Month and date in Order Date in Tableau?

Hi, you can simply drag the Order ...READ MORE

answered Aug 24, 2018 in Tableau by AwesomeSauce
• 860 points
2,703 views
0 votes
1 answer

How to add parameter and calculated field filter in tableau?

Hi Sindhu,  You cannot add parameter as a ...READ MORE

answered Mar 8, 2019 in Tableau by Cherukuri
• 33,030 points
5,070 views
0 votes
1 answer

In Tableau, How to sum the last 7 days of the value?

It can be achieved easily by creating ...READ MORE

answered Mar 12, 2019 in Tableau by Cherukuri
• 33,030 points
17,108 views
0 votes
1 answer

How to color code cells of a column based on the text value in Tableau

You can use the following steps to ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
9,832 views
+2 votes
1 answer
0 votes
1 answer

Calculated filed with if-then

Below is the required code:  IF (NOT ISNULL([test2])) ...READ MORE

answered Mar 27, 2018 in Tableau by Atul
• 10,240 points
1,561 views
+2 votes
1 answer
0 votes
1 answer

How to group bins in a tableau histogram?

One of the simple way is by ...READ MORE

answered Apr 3, 2018 in Tableau by xyz
• 1,560 points
6,803 views
0 votes
1 answer

How to use tableau to searh for text within entire data

You can use a pivot table in ...READ MORE

answered Apr 4, 2018 in Tableau by xyz
• 1,560 points
788 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP