How to show the top 10 column values in Spotfire

Question

I need to show top 10 values using Spotfire. I googled lot but I could not find the best solution.

I followed this tutorial: Creating a Dynamic Top Ten Chart but did not find success.

How can I do this?

Answer 1

How to limit a visualization by the top 10 values:

There are 2 ways you could do this. I will list them both with pros/cons.

Method 1 - Visualization Level

1. Open your visualization's properties and go to the Data tab.
2. Select "Edit..." under "Limit data using expression:" and include the following expression: Rank([values],"desc")<11 where [values] is the numeric column you want the top 10 of.

Example below. Note all of the filters are untouched on the right.

Method 2 - Analysis Level

1. Insert a calculated column with the following expression: Rank([values],"desc").
2. Use the built in filters to only include Rank 1-10 for the top 10. This will filter all of your visualizations in your given filtering scheme to just the top 10.

Example below. Note the RANK filter on the right and how I have it narrowed down to a max of 10.

Let me know if you are still having issues.

Edit: Right click and open image in a new tab if you are having trouble seeing the content of my screenshots. The source imgur link should have the larger resolution viewable.