Forum Discussion
Count Column by Group and filter
I posted before about a similar problem but I need to know how to handle multiple project. I need to know how many times a project goes in and out the " Tech Review" phase. The solution for a ta...
AlexisOlson This is the table i get when i try your solution. It is skipping values in the "How many times" column
| Project ID | Stage Id | Created | Stage_Name | Index | How many times "Tech Review" |
| 690 | 1139 | 4/21/22 | Prod Files | 1 | |
| 690 | 1031 | 4/20/22 | Tech Review | 2 | 9 |
| 690 | 1086 | 4/19/22 | Revised Proof | 3 | |
| 690 | 1140 | 4/14/22 | Revised Proof | 4 | |
| 690 | 1031 | 4/14/22 | Tech Review | 5 | 7 |
| 690 | 1086 | 2/22/22 | Revised Proof | 6 | |
| 690 | 1031 | 2/20/22 | Tech Review | 7 | 6 |
| 690 | 1022 | 2/17/22 | Graphics | 8 | |
| 690 | 1135 | 2/17/22 | Estimating | 9 | |
| 690 | 1031 | 1/28/22 | Tech Review | 10 | 4 |
| 690 | 1031 | 1/28/22 | Tech Review | 11 | 4 |
| 690 | 1023 | 1/28/22 | 1st proof | 12 | |
| 690 | 1047 | 1/27/22 | In Production | 13 | |
| 690 | 1022 | 1/27/22 | Graphics | 14 | |
| 690 | 1031 | 1/27/22 | Tech Review | 15 | 1 |
| 1143 | 1086 | 4/21/22 | Revised Proof | 1 | |
| 1143 | 1024 | 4/21/22 | Revised Proof | 2 | |
| 1143 | 1135 | 4/19/22 | Estimating | 3 | |
| 1143 | 1086 | 4/18/22 | Revised Proof | 4 | |
| 1143 | 1024 | 4/18/22 | Revised Proof | 5 | |
| 1143 | 1022 | 4/18/22 | Graphics | 6 | |
| 1143 | 1031 | 4/18/22 | Tech Review | 7 | 17 |
| 1143 | 1140 | 4/12/22 | Revised Proof | 8 | |
| 1143 | 1031 | 4/12/22 | Tech Review | 9 | 16 |
| 1143 | 1086 | 4/11/22 | Revised Proof | 10 | |
| 1143 | 1024 | 4/11/22 | Revised Proof | 11 | |
| 1143 | 1031 | 4/8/22 | Tech Review | 12 | 14 |
| 1143 | 1022 | 4/7/22 | Graphics | 13 | |
| 1143 | 1031 | 3/29/22 | Tech Review | 14 | 13 |
| 1143 | 1086 | 3/29/22 | Revised Proof | 15 | |
| 1143 | 1024 | 3/29/22 | Revised Proof | 16 | |
| 1143 | 1086 | 3/28/22 | Revised Proof | 17 | |
| 1143 | 1031 | 3/23/22 | Tech Review | 18 | 10 |
| 1143 | 1022 | 3/22/22 | Graphics | 19 | |
| 1143 | 1086 | 3/15/22 | Revised Proof | 20 | |
| 1143 | 1023 | 3/15/22 | 1st proof | 21 | |
| 1143 | 1031 | 3/7/22 | Tech Review | 22 | 7 |
| 1143 | 1022 | 3/4/22 | Graphics | 23 | |
| 1143 | 1086 | 3/3/22 | Revised Proof | 24 | |
| 1143 | 1024 | 3/3/22 | Revised Proof | 25 | |
| 1143 | 1086 | 3/2/22 | Revised Proof | 26 | |
| 1143 | 1031 | 3/2/22 | Tech Review | 27 | 3 |
| 1143 | 1031 | 2/28/22 | Tech Review | 28 | 3 |
| 1143 | 1021 | 2/24/22 | Graphics | 29 | |
| 1143 | 1031 | 2/2/22 | Tech Review | 30 | 2 |
| 1143 | 1031 | 2/2/22 | Tech Review | 31 | 2 |
| 1143 | 1031 | 2/2/22 | Tech Review | 32 | 2 |
| 1143 | 1124 | 2/1/22 | Estimating | 33 | |
| 1143 | 1031 | 1/28/22 | Tech Review | 34 | 1 |
| 1143 | 1031 | 1/21/22 | Tech Review | 35 | 1 |
| 1143 | 1136 | 1/20/22 | Sent To Client | 36 | |
| 1143 | 1124 | 1/20/22 | Estimating | 37 | |
| 416 | 1031 | 4/21/22 | Tech Review | 1 | 17 |
| 416 | 1022 | 4/20/22 | Graphics | 2 | |
| 416 | 1086 | 3/29/22 | Revised Proof | 3 | |
| 416 | 1022 | 3/29/22 | Graphics | 4 | |
| 416 | 1031 | 3/28/22 | Tech Review | 5 | 14 |
| 416 | 1022 | 3/25/22 | Graphics | 6 | |
| 416 | 1031 | 3/21/22 | Tech Review | 7 | 13 |
| 416 | 1086 | 3/21/22 | Revised Proof | 8 | |
| 416 | 1031 | 3/21/22 | Tech Review | 9 | 12 |
| 416 | 1086 | 3/21/22 | Revised Proof | 10 | |
| 416 | 1024 | 3/21/22 | Revised Proof | 11 | |
| 416 | 1021 | 3/18/22 | Graphics | 12 | |
| 416 | 1021 | 3/17/22 | Graphics | 13 | |
| 416 | 1021 | 3/15/22 | Graphics | 14 | |
| 416 | 1135 | 3/11/22 | Estimating | 15 | |
| 416 | 1086 | 3/9/22 | Revised Proof | 16 | |
| 416 | 1031 | 3/3/22 | Tech Review | 17 | 5 |
| 416 | 1024 | 3/1/22 | Revised Proof | 18 | |
| 416 | 1135 | 3/1/22 | Estimating | 19 | |
| 416 | 1031 | 2/4/22 | Tech Review | 20 | 3 |
| 416 | 1031 | 2/3/22 | Tech Review | 21 | 3 |
| 416 | 1031 | 2/3/22 | Tech Review | 22 | 3 |
| 416 | 1031 | 2/2/22 | Tech Review | 23 | 3 |
| 416 | 1031 | 2/1/22 | Tech Review | 24 | 3 |
| 416 | 1031 | 2/1/22 | Tech Review | 25 | 3 |
| 416 | 1031 | 2/1/22 | Tech Review | 26 | 3 |
| 416 | 1031 | 1/28/22 | Tech Review | 27 | 3 |
| 416 | 1031 | 1/25/22 | Tech Review | 28 | 3 |
| 416 | 1031 | 1/18/22 | Tech Review | 29 | 3 |
| 416 | 1031 | 1/17/22 | Tech Review | 30 | 3 |
| 416 | 1031 | 12/17/21 | Tech Review | 31 | 3 |
| 416 | 1031 | 12/8/21 | Tech Review | 32 | 3 |
| 416 | 1022 | 12/7/21 | Graphics | 33 | |
| 416 | 1031 | 12/3/21 | Tech Review | 34 | 2 |
| 416 | 1061 | 12/3/21 | Graphics | 35 | |
| 416 | 1031 | 12/2/21 | Tech Review | 36 | 1 |
| 416 | 1031 | 11/23/21 | Tech Review | 37 | 1 |
| 416 | 1133 | 11/22/21 | Follow up | 38 | |
| 416 | 1138 | 11/22/21 | Scheduling | 39 | |
| 416 | 1113 | 11/18/21 | Clarification | 40 | |
| 416 | 1021 | 11/17/21 | Graphics | 41 |