Hi,
I have a pivot table similar to below. Each person is given a score every week and I have the expression varX that calculates it. I show it below for clarity. I want to get a % of the scores within a performance range for each week. I will be working with four UNEVEN ranges. I tried the set analysis format below but it does not work. It returns a number but if I change the number the returned values don't change. I suspect its counting everything. Thank you in advance for any ideas.
Returns a number but changing ranges has no effect:
vTier2=Count({$<vScore={">.85<=.90"}>}Name)
| Name | Week # |
|---|
| Person A | varX=.75 |
| Person B | varX=.8 |
| Person C | varX=.82 |
| Person D | varX=.73 |
| Person E | varX=.91 |
| Person E | varX=.84 |
p.s. I am new to QV and find the syntax confusing with the use of single vs. double quotes and where to place symbols. So if you can explain any incorrect syntax I would appreciate it!
