Forum Discussion
Cumulative Unfinished Projects
Hi, I need both a bar graph and the underlying details (in a table) to show projects when they started until they finish, carrying over unfinished projects into the next quarter. Basically the d...
what would the expected result look like?
| 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.