Forum Discussion
Cumulative Unfinished Projects
| Fiscal Year Quarter | Project | Status | Count |
| 2022Q1 | A | 0 | |
| 2022Q1 | B | 0 | |
| 2022Q2 | A | In Progress | 1 |
| 2022Q2 | B | 0 | |
| 2022Q3 | A | In Progress | 1 |
| 2022Q3 | B | Not Started | 1 |
| 2022Q4 | A | Done | 1 |
| 2022Q4 | B | Not Started | 1 |
| 2023Q1 | A | 0 | |
| 2023Q1 | B | Not Started | 1 |
| 2023Q2 | A | 0 | |
| 2023Q2 | B | Not Started | 1 |
| 2023Q3 | A | 0 | |
| 2023Q3 | B | Not Started | 1 |
| 2023Q4 | A | 0 | |
| 2023Q4 | B | Not Started | 1 |
| Total | 9 |
I love this solution but if I try to graph this measure, I get a different result. I am hoping again to have the max status per project per quarter and I get multiple values here because of the sumx. The table looks just great but definitely would need to adjust to see this more visually?
Any thoughts.
Thanks
That is a very different question and requires you to know all possible statuses (stati?) beforehand.
By the way,
the max status per project per quarteris again a very different question. You would need to indicate what "max" means in your context.
The statuses are the same: Done, In Progress, Not Started.
I apologize as I thought it would solve both.
Basically if i added a third item C that changed statuses in the quarter, I would pull done for that project and quarter.
Both the table and graph would only show a max of 1 per project per quarter. You would take Done if Done, In Progress if applicable and otherwise not started. Once the project is done, it obviously would not continue and would be blank (same if the project first appears after the quarter)
Basically if i added a third item C that changed statuses in the quarter, I would pull done for that project and quarter.
ProjectFiscal Year QuarterStatus
Project Fiscal Year Quarter Status A 2022Q2 In Progress A 2022Q4 Done B 2022Q3 Not Started C 2022Q3 Not Started C 2022Q3 Done Results Table Project A B C 2022Q2 In Progress 2022Q3 In Progress Not Started Done 2022Q4 Done Not Started Thanks and sorry for the confusion.