Exploring, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Ranking in VA

Reply
Occasional Contributor
Posts: 7

Ranking in VA

Hi Everyone,

                    I want bottom rank based on conditional parameter in SAS VA 7.3 for instance suppose if i will enter value  more than 500 than the list table should reflect the value greater than parameter and apart from that i want bottom 5 ranks based on that parameter only.So if there are 10 rows which would reflect data but i need bottom 5 only based on above parameter hence not considering rows below 500.

Kindly suggest me a solution.

 

Regards,

Harsh Patel.

Contributor
Posts: 28

Re: Ranking in VA

Hi Harsh,

 

You place a filter on the conditional parameter by selecting value greater than 500. And then go to Ranks tab, create a rank on that parameter with Bottom 5 condition so that you will get the desired values which you are looking into..

 

Regards

Sandy

Occasional Contributor
Posts: 7

Re: Ranking in VA

Posted in reply to sandykota
Thanks but in parameters we can't give filters because it is a text input
object and in any parameters we can't give filters.
Ask a Question
Discussion stats
  • 2 replies
  • 143 views
  • 0 likes
  • 2 in conversation