I have a table with incident numbers, day and description. Sometimes one incident number is impacting two tools then it shows both tools however it duplicates the rows for creation day and description. Is there any way to merge those duplicated rows?
@Pablo Torres
Hi, maybe you can concatenate the max and the min of the impacted tools (this is not perfect if you have more tools impacted, but it may be a good beggining)
{FIXED [Incident Number]: MAX([Tool])+"-"+MIN([Tool])}Then replace in your viz the Tool Field, with the calculated field we just created.
If this post resolves the question, would you be so kind to "Select as Best"?. This will help other users find the same answer/resolution and help community keep track of answered questions. Thank you.
Regards,
Diego Martinez
Tableau Visionary and Forums Ambassador
