BookmarkSubscribeRSS Feed
Delen
Calcite | Level 5

In SAS Viya (for Learners), in Explore and Visualize Data, how do you make the Aggregation method for a numerical variable specific to a single chart? For instance, if I use “Average” as the aggregation for a numerical value for a specific chart, it shows the average value of that variable on all of the charts in the complete report.  

 

Similarly, how do you make the filters specific to a single chart or all of the charts. 

 

Pre-Viya version of SAS VA had those options available. I am having hard time finding them in Viya version. 

 

Thanks,

 

D. Delen

2 REPLIES 2
FredrikE
Rhodochrosite | Level 12

Hi!

The easiest might just do duplicate the variable in the data pane and change the aggregation. Maybe name the variables so the aggregation is clear when using the variable:

Variable_sum

variable_avg

variable_max

...

...

 

At least you are not limited to what options each object has 🙂

 

//Fredrik

Delen
Calcite | Level 5
Thank you for the reply. I think it is an okay remediation. I still wish we would have the option of defining Aggregation type of a variable at the chart level.



D. Delen


sas-innovate-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


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