Jump to content

Recommended Posts

Posted

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

Posted

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.

Posted

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 .

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...