topic Re: Dynamic percentage calculations in SAS Visual Analytics

Dynamic percentage calculations

sasuser381 — Tue, 26 Jun 2018 10:58:22 GMT

Hello everyone,

Variables I have on my chart are:

measures

- total number of customers (1)

-number of customers who have certain product (2)

dimensions

-months

interactive filters are:

-products (you can choose only one)

-activity (you can check 1 of them or both if you want to see numbers for all customers )

-wage category (also 1,2 or 3)

what I want is to calculate percentage of numbers of customers with product for each month, but for each combination of filters.

For example: if I check customers from 2 activity categories and 1 wage category, for 1 activitiy and 1 salary category etc...So for each combination of filters I need different calculations.

How can I do that?

Version of SAS VA I use is

SAS® Visual Analytics Hub 7.2

Thank you in advance.

Re: Dynamic percentage calculations

MikeJenista — Tue, 26 Jun 2018 14:37:09 GMT

At first glance, it sounds like an aggregated calculation will work. But what exactly is your 'chart'? A crosstab or list table? A bar chart? The possibilities will be different based on what kind of chart you are using because the number of measures you can assign will be different.

Re: Dynamic percentage calculations

FredrikE — Wed, 27 Jun 2018 06:29:42 GMT

Not really sure what you want, but by using cross tables and/or a set of objects you should be able to get what you want....:)

//Fredrik

Re: Dynamic percentage calculations

sasuser381 — Wed, 27 Jun 2018 08:37:07 GMT

Thank you very much, aggregated calculations worked for me, because measures are calculated after filtering. 🙂