Jump to content

how to rank dynamically in spotfire when the dropdown is used to filter the data

meltem nezirova

Recommended Posts

I have a line chart that uses dropdown to filter the data. I always want to show the top 10 values whatever the dropdown is. I don't want to make the top 10 values for all the data. I tried Intersect expression for the calculated column to rank the databut it didn't work I expected. Is there any other way to do this


DenseRank(First([YValue]) over (Intersect([A],All(),All([C]))),"desc")

Link to comment
Share on other sites

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...