Task counts dataset
The task counts dataset is a canonical-based dataset that offers a comprehensive view of task-related work items across planning levels or teams. It captures the total number of tasks and tracks their statuses, including open, in progress, or completed. This dataset helps you monitor task distribution and workload, enabling teams to effectively manage their task backlog and overall progress. Key insights include task completion rates, outstanding tasks, and active workload, giving a clear picture of task flow and team productivity.
note
This dataset's metrics cannot be combined with metrics from other datasets. It is intended for use in date-based analysis only.
The following are the components of this dataset:
Attributes
| Attribute Name | Description |
|---|---|
| Calendar date | Canonical calendar date attribute |
| Sys_source | Unique identifier for the source |
| Task | Unique identifier for the task |
Metrics
| Metric Name | Description | Formula |
|---|---|---|
| Closed tasks | The number of tasks closed on the selected calendar date | count(case when closed datetime is not null then task_id else null end) |
| Completed tasks | The number of tasks completed on the selected calendar date | count(case when completed datetime is not null then task_id else null end) |
| Created tasks | The number of tasks created on the selected calendar date | count(task_id) |
| In progress tasks | The number of tasks currently in progress on the selected calendar date | count(case when inprogress datetime is not null then task_id else null end) |