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 2024

Innovate_SAS_Blue.png

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