Which Days Appear in Daily Log Completion?
Answer
Daily Log Completion has one row for each project and each calendar day. Use it to see which days are complete, which days are ready to complete, and which days are still missing.
What does each row mean?
Consider reading "Missing Day," "Completable," and "Completed" together.
Missing Day = Yes. The day is not ready to complete, and nobody has marked it complete. This includes:
Days nobody opened
Days with only weather or photos
Days that still have entries pending approval
A day is ready to complete when Daily Log completion is turned on for the project, the day has at least one approved entry that counts, and no entries are pending. Weather and photos do not count.
Completable = Yes and Completed = No. The day is ready to complete, and nobody has marked it complete.
Completed = Yes. Someone marked the day complete.
Distributed = Yes after that log is distributed. All other days show Distributed = No, including missing days.
Which projects are included?
A project is included when it has ever had a day that was ready to complete. That day can sit outside the dates on your report.
A project that has never had a day ready to complete does not appear. This includes months where every day is missing.
Which days are included?
For projects that are included, every calendar day in the range is a row, including weekends.
The range starts on the earliest of:
The actual start date. This comes from the project schedule. If the project has no schedule, or the start-date override is on, it uses the override date.
The estimated start date.
The first day that was ready to complete.
The range ends on the latest of:
The projected finish date. This comes from the project schedule. If the project has no schedule, or the end-date override is on, it uses the override date.
The estimated completion date.
The last day that was ready to complete.
The range never goes past tomorrow.
A month with no logs can still show missing days when that month is inside this range. A month after the range ends has no rows.
Filters
Goal | Recommended Filters |
|---|---|
Find days that are not ready to complete | Missing Day = Yes |
Find days that should be completed and are not | Completable = Yes and Completed = No |
See every day in a period | Leave Missing Day, Completable, and Completed unfiltered. Filter Log Date and Project. |
Hide weekends or other non-working days | Day of Week |
Note the following values:
Completable:
Yes: The day is ready to complete.
No: A log exists, and the day is not ready to complete.
Blank: Nobody opened that day.
Completed:
Yes: The day was marked complete.
No: A log exists, and the day was not marked complete.
Blank: Nobody opened that day.
Common questions
Why does a project with no daily logs this month still appear?
The date range follows the project dates and the first and last day that was ready to complete. It does not follow whether someone created a log in the month on your report. If that month is inside the range, every day in the month is a row. Days that are not ready to complete show Missing Day = Yes.Why is a project missing from the report?
One of these is true:The project has never had a day that was ready to complete. Opening the Daily Log, or adding only weather or photos, does not bring the project in.
The date range ends before the period on your report. The range ends on the latest of the projected finish, the estimated completion date, and the last day ready to complete. When all three fall before the filtered period, that period has no rows.
Does the report track whether a day was viewed?
No. Opening a day creates a log for that date. Missing Day stays Yes until the day is ready to complete, or someone marks it complete. Weather and photos do not make a day ready to complete.
Why does the report return fewer rows than expected?
Check the Completable and Completed filters first. Unchecking Yes on either filter removes those days. A project that logs on a regular schedule can look empty, while a project with missing days still shows rows.
Completable = No does not list every missing day. No means the day was opened and is not ready to complete. Days nobody opened are blank.
See Also
Loading related articles...