Count if (x/stdev(y))<5

[#1]

I need a table that counts only values that fulfill my condition {exp: (x/stdev(y)<5} without the "stdev(y) it works fine like

count( if( x<5, x))

but something like

count( if(stdev(x)<5,x))

wont work.

[#2]

Hi, if you trying to use the same field ("x"), remember that inside Count function every value for "x" will be equal to stdev(x), because only that specific x value will be touched.

Use stdev(TOTAL x) instead.

[#3]

Set analysis might be a better solution if you have dimensions to display.