Forum Discussion
Time Sensitive project count
Below is a table of data on a few projects. Anytime a projects changes hands, a new line item in added with the date and the stage associated.
My question is how can I create a meaure that looks at total Projects assigned by stage for a current date. The issue I am running into is that it only is counting projects with that filtered date stamp. But some projects have been sitting in a stage for a long time so they do not have a upto date stamp. I need a time sensitive Number of Project by stage for anything that was assigned prior to the filtered date.
Basically I am trying to measure how many projects per stage were there at the beginning of each month.
| Project ID | Stage Id | Created | Stage_Name | Index |
| 690 | 1139 | 4/21/2022 | Prod Files | 1 |
| 690 | 1031 | 4/20/2022 | Tech Review | 2 |
| 690 | 1086 | 4/19/2022 | Revised Proof | 3 |
| 690 | 1140 | 4/14/2022 | Revised Proof | 4 |
| 690 | 1031 | 4/14/2022 | Tech Review | 5 |
| 690 | 1086 | 2/22/2022 | Revised Proof | 6 |
| 690 | 1031 | 2/20/2022 | Tech Review | 7 |
| 690 | 1022 | 2/17/2022 | Graphics | 8 |
| 690 | 1135 | 2/17/2022 | Estimating | 9 |
| 690 | 1031 | 1/28/2022 | Tech Review | 10 |
| 690 | 1031 | 1/28/2022 | Tech Review | 11 |
| 690 | 1023 | 1/28/2022 | 1st proof | 12 |
| 690 | 1047 | 1/27/2022 | In Production | 13 |
| 690 | 1022 | 1/27/2022 | Graphics | 14 |
| 690 | 1031 | 1/27/2022 | Tech Review | 15 |
| 1143 | 1086 | 4/21/2022 | Revised Proof | 1 |
| 1143 | 1024 | 4/21/2022 | Revised Proof | 2 |
| 1143 | 1135 | 4/19/2022 | Estimating | 3 |
| 1143 | 1086 | 4/18/2022 | Revised Proof | 4 |
| 1143 | 1024 | 4/18/2022 | Revised Proof | 5 |
| 1143 | 1022 | 4/18/2022 | Graphics | 6 |
| 1143 | 1031 | 4/18/2022 | Tech Review | 7 |
| 1143 | 1140 | 4/12/2022 | Revised Proof | 8 |
| 1143 | 1031 | 4/12/2022 | Tech Review | 9 |
| 1143 | 1086 | 4/11/2022 | Revised Proof | 10 |
| 1143 | 1024 | 4/11/2022 | Revised Proof | 11 |
| 1143 | 1031 | 4/8/2022 | Tech Review | 12 |
| 1143 | 1022 | 4/7/2022 | Graphics | 13 |
| 1143 | 1031 | 3/29/2022 | Tech Review | 14 |
| 1143 | 1086 | 3/29/2022 | Revised Proof | 15 |
| 1143 | 1024 | 3/29/2022 | Revised Proof | 16 |
| 1143 | 1086 | 3/28/2022 | Revised Proof | 17 |
| 1143 | 1031 | 3/23/2022 | Tech Review | 18 |
| 1143 | 1022 | 3/22/2022 | Graphics | 19 |
| 1143 | 1086 | 3/15/2022 | Revised Proof | 20 |
| 1143 | 1023 | 3/15/2022 | 1st proof | 21 |
| 1143 | 1031 | 3/7/2022 | Tech Review | 22 |
| 1143 | 1022 | 3/4/2022 | Graphics | 23 |
| 1143 | 1086 | 3/3/2022 | Revised Proof | 24 |
| 1143 | 1024 | 3/3/2022 | Revised Proof | 25 |
| 1143 | 1086 | 3/2/2022 | Revised Proof | 26 |
| 1143 | 1031 | 3/2/2022 | Tech Review | 27 |
| 1143 | 1031 | 2/28/2022 | Tech Review | 28 |
| 1143 | 1021 | 2/24/2022 | Graphics | 29 |
| 1143 | 1031 | 2/2/2022 | Tech Review | 30 |
| 1143 | 1031 | 2/2/2022 | Tech Review | 31 |
| 1143 | 1031 | 2/2/2022 | Tech Review | 32 |
| 1143 | 1124 | 2/1/2022 | Estimating | 33 |
| 1143 | 1031 | 1/28/2022 | Tech Review | 34 |
| 1143 | 1031 | 1/21/2022 | Tech Review | 35 |
| 1143 | 1136 | 1/20/2022 | Sent To Client | 36 |
| 1143 | 1124 | 1/20/2022 | Estimating | 37 |
| 416 | 1031 | 4/21/2022 | Tech Review | 1 |
| 416 | 1022 | 4/20/2022 | Graphics | 2 |
| 416 | 1086 | 3/29/2022 | Revised Proof | 3 |
| 416 | 1022 | 3/29/2022 | Graphics | 4 |
| 416 | 1031 | 3/28/2022 | Tech Review | 5 |
| 416 | 1022 | 3/25/2022 | Graphics | 6 |
| 416 | 1031 | 3/21/2022 | Tech Review | 7 |
| 416 | 1086 | 3/21/2022 | Revised Proof | 8 |
| 416 | 1031 | 3/21/2022 | Tech Review | 9 |
| 416 | 1086 | 3/21/2022 | Revised Proof | 10 |
| 416 | 1024 | 3/21/2022 | Revised Proof | 11 |
| 416 | 1021 | 3/18/2022 | Graphics | 12 |
| 416 | 1021 | 3/17/2022 | Graphics | 13 |
| 416 | 1021 | 3/15/2022 | Graphics | 14 |
| 416 | 1135 | 3/11/2022 | Estimating | 15 |
| 416 | 1086 | 3/9/2022 | Revised Proof | 16 |
| 416 | 1031 | 3/3/2022 | Tech Review | 17 |
| 416 | 1024 | 3/1/2022 | Revised Proof | 18 |
| 416 | 1135 | 3/1/2022 | Estimating | 19 |
| 416 | 1031 | 2/4/2022 | Tech Review | 20 |
| 416 | 1031 | 2/3/2022 | Tech Review | 21 |
| 416 | 1031 | 2/3/2022 | Tech Review | 22 |
| 416 | 1031 | 2/2/2022 | Tech Review | 23 |
| 416 | 1031 | 2/1/2022 | Tech Review | 24 |
| 416 | 1031 | 2/1/2022 | Tech Review | 25 |
| 416 | 1031 | 2/1/2022 | Tech Review | 26 |
| 416 | 1031 | 1/28/2022 | Tech Review | 27 |
| 416 | 1031 | 1/25/2022 | Tech Review | 28 |
| 416 | 1031 | 1/18/2022 | Tech Review | 29 |
| 416 | 1031 | 1/17/2022 | Tech Review | 30 |
| 416 | 1031 | 12/17/2021 | Tech Review | 31 |
| 416 | 1031 | 12/8/2021 | Tech Review | 32 |
| 416 | 1022 | 12/7/2021 | Graphics | 33 |
| 416 | 1031 | 12/3/2021 | Tech Review | 34 |
| 416 | 1061 | 12/3/2021 | Graphics | 35 |
| 416 | 1031 | 12/2/2021 | Tech Review | 36 |
| 416 | 1031 | 11/23/2021 | Tech Review | 37 |
| 416 | 1133 | 11/22/2021 | Follow up | 38 |
| 416 | 1138 | 11/22/2021 | Scheduling | 39 |
| 416 | 1113 | 11/18/2021 | Clarification | 40 |
| 416 | 1021 | 11/17/2021 | Graphics | 41 |
2 Replies
AlexisOlson I am tagging you because you were able to help me with one of my other issues with this data set.
Hi Anonymous ,
It doesn't seem very clear what your needs are, and what exactly the stage ID field means. For the Stage_name field, what is the complete flow of a project and what status indicates that a project is in a completed or pending state?
Could you further describe your needs and provide relevant explanatory notes. To facilitate me to answer for you as soon as possible.
Best Regards,
Henry
