Katie Sikorski Posted February 2, 2021 Share Posted February 2, 2021 Hello I am trying to rank my leases by the value. I tried Rank and instead of it ranking my leases from 1 - 4000, it is ranking them with really large numbers starting with 5 and ending with 24897. All I want to do is chart my leases based on their value from high to low with a single count. Hopefully this makes since I tried Rank([Total_Value]) but that did not work. So is there a way to just have Spotfire count in a calculated column such as 4000 - 1 based on the value. Example Below Before After Lease Value Rank Lease Value Rank Lease 1 450 4 Lease 4 8752 1 Lease 2 1200 2 Lease 2 1200 2 Lease 3 52 5 Lease 5 680 3 Lease 4 8752 1 Lease 1 450 4 Lease 5 680 3 Lease 3 52 5 Link to comment Share on other sites More sharing options...
Gaia Paolini Posted February 3, 2021 Share Posted February 3, 2021 I guess you have more than 4000 rows. Try DenseRank or RankReal, there are also parameters to set the order of ranking and/or rank by group. Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now