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...
Your source data is not in a usable format. Should be more like
| Project | Fiscal Year Quarter | Status |
| A | 2022Q2 | In Progress |
| A | 2022Q4 | Done |
| B | 2022Q3 | Not Started |
Once you have that you can use a disconnected table with your quarters and for each quarter calculate the latest recorded status for each project.
Thanks, could you expand a bit more once I have those two tables? I just struggle with how to get the results in a table versus a simple bar graph. I really need the results table to show each quarter for each unfinished project. Thanks
see attached