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