Explore Courses Blog Tutorials Interview Questions
0 votes
in BI by (17.6k points)

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.

1 Answer

0 votes
by (47.2k points)
edited by

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.

Want to be an expert in Tableau? Check out the Tableau Training to get the right assistance.

Related questions

0 votes
1 answer
0 votes
1 answer
asked Jul 23, 2019 in BI by Vaibhav Ameta (17.6k points)

Browse Categories