Hello,
I am trying to use an aggregate measure as a filter on the table, but with no success. Let’s start from the beginning, I have created an aggregated measure that calculates the average of column A. This measure is dynamic which means there are filters that affect Column A. So, the average of Column A is not a standard value. After that I need to present the values of column A that are greater than or equal to the average, is this possible? If so, how can I do this.
Thanks,
Charis
Hi @Charis_Saliaris,
in your title you ask for “filtering”, in the text you look for “presentation” of selected values.
I don’t know about a “filtering” solution in my VA 7.5 as the average (in the aggregated measure) would be recalculated with each filtering, so even theoretically one would get only a iterative process.
But there might be a presentation solution:
I can use the aggregated measure of the average in a Display rule, to white all rows with my Column A value less then the average:
If this isn’t sufficient and you have a new VA Version, maybe you will find an approach here:
SAS Visual Analytics Advanced Calculations (part 3... - SAS Support Communities
Best
Markus
Hi Markus,
Thank you for your reply.
If I have understood correct there is one way to present the values of Column A which is greater than or equal with the average is via display rules.
Also, I have tried to create a new aggregated data source, but I cannot use average (aggregated measure) as a filter.
(the photo is from SAS Visual Analytics Advanced Calculations (part 3... - SAS Support Communities)
Thank you,
Haris
Try this.
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.
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.