topic Re: Filtering based on an Aggregated Measure in Visual Analytics in SAS Visual Analytics

Filtering based on an Aggregated Measure in Visual Analytics

Charis_Saliaris — Mon, 07 Nov 2022 16:46:50 GMT

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

Re: Filtering based on an Aggregated Measure in Visual Analytics

MarkusWeick — Mon, 07 Nov 2022 18:36:22 GMT

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

Re: Filtering based on an Aggregated Measure in Visual Analytics

Charis_Saliaris — Tue, 08 Nov 2022 10:32:59 GMT

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

Re: Filtering based on an Aggregated Measure in Visual Analytics

acordes — Tue, 08 Nov 2022 13:52:26 GMT

Try this.