SpotFire analysis with repeating id in column to show once and hide the rest

[Deborah Thibodeaux]

I am trying to get a table in a data table generated in SpotFireto show only one instance of the values in a column with severalrows of repeating ID. I would like to show 1 and hide the others.

Our Database makes a copy of the data everytime an action is taken, the data is saved and creates a duplicate. The multiples all show up in the data table.

I am looking for a VBA limited statement to limit this to one instance per ID.

Alternately, how could I filter it. to accomplish this

Any ideas

Debbie

[Paul Shumaker]

You can put the following into the data limiting expression on a visualization:

Rank(RowId(),"asc",[Column ID]) = 1

This only shows the first record (if multiples exist) in an ascended rank of column IDs. Note you can pass more than one column in the argument as well.

[Deborah Thibodeaux]

Thanks. I just had a class in this level and I am still getting the nuances straightened out.

[foram merchant]

Ranking function and then limiting the data with rank =1 .

calculated column - Rank -Rank(RowId(),"asc",[Name]) (You can add , seperated Column names if hirarchy is @Multiple column level)

Please check attached fileIf it helps .