How do we say, which review is latest?
I am guessing , it is REVW_ID. If so, I will rank it by transaction id. Then I will create if statement.
if statement can be like below
if([rank] > 1 ) then ('mereged')
If you can provide tableau workbook with data. It should be easy to solve.
There is a review date field that I have. I would provide the workbook, but there are some confidentiality concerns I have that I do not know how to get around.
We can use date column if it has different values. In your example, it shows same values.
Below are guidelines from tableau regarding packaged workbook.I will create 10- 15 rows of dummy data in excel with required columns and use it.
Ah, you are right. We can merge buckets regardless of the date. Ok, so review name would be the best to use for the conditional statement. Those are assigned a unique number at the beginning of the string.