Filter visualization on mean value

scan — Tue, 14 Apr 2015 07:53:23 GMT

Hello everyone,

I have a dataset of this kind

ID	value
1	1
1	3
2	2
2	4

and, choosing avg as aggregation in a crosstab I have something like this as you know

ID	AVG value
1	2
2	3

this is plotted in a line chart.

I want to add a button bar to filter outliers where that calculated average is ge 4 or le 1 (showing only ID 1 in this sample).

Also, is it possible to do the same thing filtering values only when they are ge than the mean of avg values + 3 * their standard deviations?

(In this case mean(avg1 avg4) + 3*sd(avg1 avg4) )

I'm pretty new with sas va.

Thanks to everyone who will help.

Re: Filter visualization on mean value

Sam_SAS — Tue, 14 Apr 2015 18:31:20 GMT

Hello,

Unfortunately you cannot apply post-aggregation filters to visualizations in the data explorer.

In the report designer you can apply post-aggregation filters to many report objects, but crosstabs do not support post-aggregation filters.

https://support.sas.com/documentation/cdl/en/vaug/67500/HTML/default/viewer.htm#p0989k7vl59ugbn1183c1u36lvcn.htm

Hopefully we can support aggregated filters against crosstabs in a future release.

For the second part of your question, if I understand correctly, you want to apply nested aggregations in a filter expression (average of the average values, stddev of average values.) I don't think this is possible in our expression builder, but I'm not sure.

Thanks,

Sam

topic Filter visualization on mean value in SAS Visual Analytics

Filter visualization on mean value

Re: Filter visualization on mean value