Task Cycle Time Report View

Table 34-24 describes the WFTASKCYCLETIME_VIEW report view.

Table 34-24 Task Cycle Time Report View

^Footnote 1

NOT NULL column

For example:

Compute the average cycle time (task completion time) for completed tasks that were created in the last 30 days, as shown below:
```
SELECT avg(cycletime) FROM  WFTASKCYCLETIME_VIEW  WHERE createddate > 
 (current_date - 30);
```
Query the average cycle time for all completed tasks created in the last 30 days and group them by task name, as shown below:
```
SELECT taskname, avg(cycletime) FROM WFTASKCYCLETIME_VIEW WHERE
 createddate > (current_date - 30) GROUP BY taskname;
```

Query the least and most time taken by each task, as shown below:

SELECT taskname, min(cycletime), max(cycletime) FROM WFTASKCYCLETIME_VIEW
 GROUP BY taskname;

Compute the average cycle time for tasks completed in the last seven days, as shown below:
```
SELECT avg(cycletime) FROM  WFTASKCYCLETIME_VIEW  WHERE enddate >
  (current_date - 7);
```

Query tasks that took more than seven days to complete, as shown below:

SELECT taskname, avg(cycletime) FROM WFTASKCYCLETIME_VIEW WHERE cycletime
 > ((current_date +7) - current_date) GROUP BY taskname;