Hey all, I have been banging my head against a wall trying to figure this out, and I am sure that the solution is simple.
I have a table that lists all courses that people have taken. What I want to do is create a measure that will count the number of people that have taken atleast 3+ courses in a quarter. I have ID's for everyone, and column that lists the quarter in which the class was taken in. Each course completion gets it's own row.
Getting the count of the number of completions for each employee is easy, but when I filter by quarter and only 3+ courses, the count is including people who have taken 3+ courses for the year, and it doesn't seem to be taking in the Quarter filter into consideration.
I want to turn a table from this:
Row Labels Q1 Q2 Q3 Q4 Grand Total
| 10000258 | 6 | 1 | 2 | 3 | 12 |
| 10001984 | 25 | 8 | 3 | 6 | 42 |
| 10002072 | 4 | 2 | 1 | | 7 |
Into this:
Row Labels Q1 Q2 Q3 Q4 Grand Total
| CCG | 1315 | 812 | 708 | 836 | 3671 |
| DCG | 1429 | 1038 | 887 | 911 | 4265 |
| IoTG | 801 | 595 | 540 | 551 | 2487 |
| NSG | 956 | 661 | 554 | 605 | 2776 |
By summarizing each persons completions and then bucketing them and filtering by 3+ Completions. Does anyone know how I can accomplish this? Or point me in the right direction?
Thanks.
