BookmarkSubscribeRSS Feed
AndreasR
Calcite | Level 5

My question is: How to compute the overall average of ratios (aggregated measures) in SAS VA?

Let's say I have data on turnover and profit by day and want to sum it by month, compute the profit ratio by month (as an aggregated measure) and then compute the average of those individual profit ratios? I dont see a way to do this without a seperate data source (pre aggregated or aggregated data source in VA). 

If I would just want the average of the individual sums of profit by month, then I could use the "aggregated table operator": First sum by month and then average for the total. But with ratios I dont see, how this could work!

SAS Innovate 2025: Save the Date

 SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!

Save the date!

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
  • 0 replies
  • 2250 views
  • 0 likes
  • 1 in conversation