BookmarkSubscribeRSS Feed
Calcite | Level 5

SAS Visual Analytics 7.4 Hotfix 09


I'm making a crosstab.  My raw data is a result by 2 categories.  1st data column is an average of the result, 2nd column is a count of the results, 3rd column is a count of results less than a certain value (number of "failures"), 4th column is supposed to be the percentage of the 3rd column/2nd column.  Basically it's a failure percentage.


For the 4th column, i made a calculated item of  (column_2)/(column_3).  But since I'm forced to choose an aggregation for the calculated measured value, I don't get the actual raw percentage calculation. 


In case it matters, I have the report filtered for the current month/year.


How do I set up my 4th column?

Calcite | Level 5

I figured out my problem.  I didn't create New Aggregate Measures, I just changed the aggregations of data columns.  When I created new aggregate measures, I was able to get calculate percentages using them like I needed.





Registration is open! SAS is returning to Vegas for an AI and analytics experience like no other! Whether you're an executive, manager, end user or SAS partner, SAS Innovate is designed for everyone on your team. Register for just $495 by 12/31/2023.

If you are interested in speaking, there is still time to submit a session idea. More details are posted on the website. 

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
  • 2 replies
  • 2 in conversation