BookmarkSubscribeRSS Feed
0 Likes

Today a user asked how to show the top 2 values for each bygroup in a VA object on the VA community.

 

We don't seem to have a good way to do this in VA. It seems like it would be a logical feature to add a "Context" option on the rank definition on the Ranks pane to let you switch between the ByGroup and ForAll contexts, similar to the _ByGroup_ | _ForAll_ context we specify for aggregations in the expression editor.

 

For example, if we have this crosstab:

rankby.png

 

We could make a ranking on Model that would return the top two models for each Type category:

 

rankby1.png

 

Currently I believe this can only be achieved with by precalculating the rank.