pajarvey
New member
- Joined
- Nov 4, 2011
- Messages
- 3
- Reaction score
- 0
- Points
- 0
I'm struggling with something that should be simple - I'm sure I'm missing something obvious:
I'm trying to count the number of values that are below the average (plus a little filtering).
I have one data set, with two columns
column1 || column2
6 || 1
5 || 1
7 || 1
6 || 1
5 || 2
7 || 2
6 || 2
I simply want a measure that will return the number of values in column1, for which two criteria are true:
I'm trying to count the number of values that are below the average (plus a little filtering).
I have one data set, with two columns
column1 || column2
6 || 1
5 || 1
7 || 1
6 || 1
5 || 2
7 || 2
6 || 2
I simply want a measure that will return the number of values in column1, for which two criteria are true:
- [column2]=1
- [column1] is above the average of values in [column1] for which column2 = 1