Spotfire Ideas Portal
It would be great to add a "distinct" option in Table visualisations to remove duplication if required. The Distinct option should have 2 modes, one which looks at all the underlying data in the table for creating the distinct data set. The other option should allow the distinct functionality to only operate over the columns added to the table.
At the moment, when wanting to create a distinct view of data, you either have to use a cross table, often when you don't require a cross table...or you have to create a separate data set.
Appreciate your help. The only issue with the rank solution is having a formula tied to the columns you are presenting. Add or remove a column from the table - update the calculated column.
Yes, I´m not at all arguing against that it would be valuable to have short-cut for the common case. Just wanted to share a way to do what you are asking for using some of the functionality that is already available.
Thanks. Now imagine how easy it would be to have a remove duplicates option on the table visualisation which operated over the displayed columns.
You can identify duplicate rows using a calculated column. E.g if you insert a calculated column with the name Duplicate using the following expression:
Rank(Baserowid(),"asc",[Country Name],[Region])>1
It will have the value False for the first occurrence of each combination of Country Name and Region and true for all others. You can add as many columns as you want to the expression.
Once you have this column you can use the filters to filter them out completely from all visualizations or calculations or just hide them in a particular visualization such as a table using the show/hide rules:
Once you added the rule as shown in the screenshot you will have a checkbox that you can use to toggle duplicated rows on and off in the table. The following knowledge base article gives you some more information and tips on how to deal with duplicate data:
https://support.tibco.com/s/article/How-to-remove-duplicate-rows-in-TIBCO-Spotfire