topic Re: calculate % column total? in SAS Visual Analytics

calculate % column total?

JianShen — Mon, 16 Aug 2021 14:50:59 GMT

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:

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

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

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?

Re: calculate % column total?

Madelyn_SAS — Fri, 20 Aug 2021 16:18:14 GMT

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

Re: calculate % column total?

acordes — Wed, 22 Sep 2021 22:56:14 GMT

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.

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

Re: calculate % column total?

ThdB — Tue, 28 Sep 2021 14:07:09 GMT

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 😉

Re: calculate % column total?

acordes — Tue, 28 Sep 2021 14:28:59 GMT

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.