BookmarkSubscribeRSS Feed
sas_it
Quartz | Level 8

Pls help regarding the below thing :

 

I have the variables as follows :

 

d_com  p_pending

0                     1

0                     0

1                     1

 

So in Visual analytics i want the total count of the variables alone.

 

I checked as follows as calculated data item :

if(d_com  = 1) then return 1 else 0;

And then I converted to Category because I want to create hierarchy. But it shows the values as 1 and 0 again. I just want total in hierarchy. How to do it..? Pls help.

 

1 REPLY 1
SASKiwi
PROC Star

You probably need to create an aggregated measure based on your calculated item so that it will sum up.

SAS Innovate 2025: Call for Content

Are you ready for the spotlight? We're accepting content ideas for SAS Innovate 2025 to be held May 6-9 in Orlando, FL. The call is open until September 16. Read more here about why you should contribute and what is in it for you!

Submit your idea!

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
  • 1 reply
  • 921 views
  • 1 like
  • 2 in conversation