Conclusion

Of 289 issues in the sample workbook, 22 are finished and 221 are already past their due date. The unfinished items are old, safety is the largest group, and many rows are missing a place or a date.

Step
8
Finished
22
Overdue
221
As of
13 Oct 2026

This page reads the four published charts together for someone who does not work in Power BI. Every count comes from Snowden Towers Sample Issue Summary.xlsx, ingested 2026-10-13T17:38:40+11:00. It is the sample issue file for this practice project, not a separate site diary. Assigned to and company are Autodesk on all 289 rows.

What the four pages are

The same 289 issues are drawn four ways. None of the charts invents a fifth list. A year tick on the overview page narrows that one page. With no year ticked, the cards are the full file. The executive page is the same workbook, filtered by category rather than by year.

QuestionPage
How many issues are there, and how many are finished?Overview
How many are late, and how old is the unfinished work?Lifecycle
Which kind of issue is most common?Safety
Can a single row be trusted for place and dates?Register

Words used on the charts

The charts keep the workbook’s own status words. Two of those words mean finished. The other seven mean the issue is not finished. “Open” is only one of the seven.

WordPlain meaningIssues
FinishedStatus Closed or Completed. The charts keep those two labels apart.22
Not finishedAny other status.267
OpenOne not-finished label. It is not the whole backlog.148
OverdueNot finished, and the due date is before 13 October 2026.221
No due dateNot finished, and the due-date cell is empty. These are not called overdue.45
Due laterNot finished, and the due date is still ahead.1

Almost all of the work is still open

The overview page is the headline. With every year included it shows 289 issues, 148 with status Open, 267 not finished, 22 finished, and a finish rate of 7.61%. That rate is 22 divided by 289. About eight issues in a hundred are finished.

The other not-finished labels, besides Open, are In dispute 51, Draft 46, In progress 7, Pending 7, Not approved 5, and In review 3. A reader who looks only at the Open card will miss 119 issues that are also not finished.

New issues were recorded from September 2023 through August 2026. The years hold 22, 39, 112, and 116 issues. October 2025 is the busiest month, with 29 new issues. March 2024, April 2024, and March 2025 have none.

Most unfinished issues are already late

The lifecycle page asks a different question: of the issues that are not finished, how many should already have been done? On 13 October 2026 the answer is 221. That is 76.47% of the whole file, about three issues in four.

Forty-five unfinished issues have no due date, so they are left out of the overdue count. Two finished issues also have no due date, which is why the register’s “missing due date” card reads 47 rather than 45. One issue is still in the future: #1712, due 14 January 2027. Nothing else is due between 13 October and 20 October 2026, so the “due in the next 7 days” card is blank.

The unfinished issues are old. Their average age, from the day each one was created to 13 October 2026, is 407.76 days, a little over a year. This is not a pile of items that came due this week. It is a backlog that has been sitting.

Inside the 221 overdue issues, 114 are Open, 50 are In dispute, and 37 are Draft. Safety has 66 overdue, Concrete Crew 41, and Punch List 39. Those three groups are more than half of the late work.

Safety is the largest group

The safety page counts 73 safety issues, 67 of them not finished, which is 25.26% of the file. The 73 is the Safety category (72) plus one XL Safety row. That extra row is already Closed, so it does not add to the 67. The bar labelled Safety on the category chart stays at 72. Life Safety - Design is a different category and is not inside the 73.

The most common type is Safety Infraction, with 71 issues. After that come COI (33) and Punch List (31). Punch List as a category is 55, and Concrete Crew is 50. Together with Safety, those three categories are 177 of the 289 issues.

Safety issues were recorded from September 2023 to May 2026. They rose in late 2025 and peaked in January 2026, with 13, then 10 in February. That peak is not the same month as the overall peak. The whole file was busiest in October 2025. The safety line was busiest three months later.

Many rows cannot yet be chased from the file alone

The register page is the caution. It does not change the totals. It shows which cells are empty, and which dates disagree with the status.

GapWhat a reader should allow for
47 issues have no due dateThey cannot be called late or on time. Forty-five of them are not finished.
208 issues have no locationOnly 81 name a place. A walk-down list cannot be built from the file alone.
185 issues have no start date104 have one. Start date is not a reliable clock.
12 closure dates disagree with the statusAll 11 Closed rows have a closed-at time. Ten of the 11 Completed rows do not. #1442 is still Open and #1122 is still Pending, yet both have a closed-at time.
1 issue is Unpublished#1638, Design Conflict, status Not approved. The other 288 are Published.

Because closed-at and status disagree on those 12 rows, this set of pages does not report how many days an issue took to finish. A finished label and a closure time are not yet the same fact.

What to take from the set

Read as one pack, the charts say four things. Very little of the file is finished. Most of what remains is already past the date it was due, and it has been open for about a year on average. Safety, punch list, and concrete crew account for most of the rows, and for most of the late ones. The file is not yet a complete place-and-date register, so a single row should be checked on the register page before anyone treats its dates as settled.

The row list, without the due-date columns, is the issues page. The path back to how the file was checked is the Power BI path.