BookmarkSubscribeRSS Feed
JianShen
Obsidian | Level 7

Hi all,

 

Currently, I am trying to show a top 5 rank in VA within a list table. Showing just the top 5 rank in itself works fine. However, I have now been asked to show how much % of the total a score is. 

 

For example, my data looks like the following:

 

 Example Data.PNG

I would then like to show the results in a top 5, like this:

 

Example wanted result.PNG

 

However, what currently happens is that VA only calculates and shows the total, based on the visible rows, like this:

 

JianShen_0-1629125334795.png

 

As such, I was wondering if it's possible to calculate a % of the total within a column in VA version 7.5, while only showing a top 5 rank?

 

 

4 REPLIES 4
Madelyn_SAS
SAS Super FREQ

If you include the All Other in the ranking, does it rank the percentages as you would like? 

 

acordes
Rhodochrosite | Level 12

One possible solution is to create a aggregated table and include the calculated percentage as a variable.
With the aggregated table the variable becomes static in the scope of this table.
Now you can rank based on the top5 and show the share correctly. The last object builds upon the aggregated table.

a1.png


I present you an alternative as well:
There is a pareto example out there in the communities which uses job execution for that purpose.

ThdB
Obsidian | Level 7

I would add the "All other" ranking.

When you create an aggregated table, you won't be able to calculate correct percentages when you start adding filters to your report or when change the variables in your rows.

Been there, done that 😉

 

acordes
Rhodochrosite | Level 12

If I do not understand wrongly your concern, you can achieve updating the aggregated table correctly applying parameters in the filter of the aggregated table.

this should keep them synchronized.

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

Tips for filtering data sources in SAS Visual Analytics

See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 4 replies
  • 597 views
  • 0 likes
  • 4 in conversation