Fluorite | Level 6

## Filtering based on an Aggregated Measure in Visual Analytics

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

3 REPLIES 3
Barite | Level 11

## Re: Filtering based on an Aggregated Measure in Visual Analytics

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

Like posts you agree with or like. Mark helpful answers as “accepted solutions”. Generally have a look at https://communities.sas.com/t5/Getting-Started/tkb-p/community_articles
Fluorite | Level 6

## Re: Filtering based on an Aggregated Measure in Visual Analytics

Hi Markus,

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.

Thank you,

Haris

Rhodochrosite | Level 12

## Re: Filtering based on an Aggregated Measure in Visual Analytics

Try this.

Discussion stats
• 3 replies
• 605 views
• 2 likes
• 3 in conversation