I downloaded an onboarding template that calculates the number of Initiated task's and incompletes vs. completes for 2023 and 2024. For some reason the initiated task numbers have started to decrease which is unexpected since we are no longer in 2023. I would have thought this number would stay static as task's that were initiated in 2023 should be be initiated in 2024. The latest delay we have on a task is 120 days. Below is the filter and columns I am outputting. We went live in 2023, so there is no filter on Date.
Incomplete formula: FILTER("Checklist Task"."Count" USING ("Allocated Checklist"."Status Code" <> 'COM'))
Complete formula: FILTER("Checklist Task"."Count" USING ("Allocated Checklist"."Status Code" = 'COM'))
Creation Date: YEAR("Allocated Checklist"."Creation Date")initiated: "Checklist Task"."Count"