Hello Team,

I need guidance on creating a dashboard that tracks historical task delays per employee, not just the current task status.

Scenario:

A task is assigned to Employee A.

The task misses its due date and is marked as Delayed.

Later, the task is reassigned to Employee B and eventually completed.

Currently, when the task is completed or reassigned, it disappears from delay-based dashboards, or the responsibility shifts.

Requirement:

I want to permanently capture and report:

Which employee caused the delay

On which date the task became delayed

A count of how many times tasks were delayed by each employee

This data should:

Remain unchanged even if the task is reassigned

Remain visible even after the task is completed

Be usable in dashboards for daily, weekly, and monthly reports

Question:

What is the best ClickUp-supported way to lock historical delay accountability per user?

Is using custom fields with automations the recommended approach, or is there a native reporting feature for historical delay tracking?