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

Dynamic percentage calculations

Accepted Solution Solved
Reply
New Contributor
Posts: 4
Accepted Solution

Dynamic percentage calculations

[ Edited ]

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.


Accepted Solutions
Solution
‎06-27-2018 04:35 AM
SAS Employee
Posts: 31

Re: Dynamic percentage calculations

Posted in reply to sasuser381

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.

View solution in original post


All Replies
Solution
‎06-27-2018 04:35 AM
SAS Employee
Posts: 31

Re: Dynamic percentage calculations

Posted in reply to sasuser381

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.

New Contributor
Posts: 4

Re: Dynamic percentage calculations

Posted in reply to MikeJenista

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

PROC Star
Posts: 398

Re: Dynamic percentage calculations

Posted in reply to sasuser381

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....Smiley Happy

//Fredrik

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 3 replies
  • 154 views
  • 0 likes
  • 3 in conversation