Selecting dimensions with average measure...

[markp201]

I have multiple measures by country and I would like to select any country with an average within a range.

For example, select all country's with an average "score" between 2 and 3.

What I get is a list of country's where any of the raw values is between 2 and 3.

Country	Measure	Value
A	X	1
A	Y	2
A	Z	3
B	X	2
B	Y	4
B	Z	6
C	X	1
C	Y	1
C	Z	1

[sunny_talwar]

How will the filter look like? 2-3 or are you planning to get this as an input from users in a input box?

[johnw]

I believe use this as your select expression?

=avg(Value)>=2 and avg(Value)<=3