×
Menu

Bitrix24. Tasks

Tasks with overlapped chart for ratios: created, completed, to be done, overdue.
Learn tasks with links to leads, deals, contacts.
 
 
Click "Show SQL after loading" If you want to see SQL editor. See the details here (3)
Select "Next".
 
The ratios in the Ratios tab:
 
 
 
 
Created - the count of tasks created during the selected period
 
Completed - the count of tasks completed during the selected period, for any creation date. /note 1*
 
Standard Task ratios have different base dates: the "Created" ratioc is the creation date, the "Completed" ratio is the completion date. For example, in a week you could create ten tasks and complete 100 from previous periods.
 
 
To be done - the count of tasks to be completed at the end of the selected period.
 
Overdue - Overdue at the end of the selected period.
 
Overdue ever - By this ratio, you can roughly understand how many tasks were involved. If the task was created BEFORE the period and completed after or not completed, it will not get here. But it will be in the “To be completed” ratio.
 
Average speed fast/plan, % - The speed of completing tasks, where the fact is the time from task creation to completion , and the plan is the time  from task creation to deadline. A score above 100% ratios overdue tasks, and less than 100% ratios completed on time. Thanks to the “speed” ratio, you can distinguish tasks that you tried to complete but did not manage to complete, for example, these are tasks up to 120% speed, and separately highlight tasks that were treated negligently. For example, these are those where the speed is above 200%, that is, they were made more than twice as long as planned.
Average speed is measured in working hours.
 
Without deadline - Uncompleted tasks without a deadline at the end of the selected period.
 
Overdue / to be done - Percentage of overdue tasks to completed tasks
 
Average duration -  average duration of work with tasks
 
Time spent - total time spent on tasks
 
The ratios inthe Data tabe
 
 
 
Working hours - is the duration of the task, which does not include weekends and non-working hours.
Planned Working hours - is the planned duration of the task, which does not include weekends and non-working hours.
 
 
speed, fact/plan, % - Task Completion Time By Responsible (Fact)/ Scheduled Time for Task Completion (Deadline minus Start Date) *100%
After deadline - time after deadline
After deadline Working hours - time after deadline, which does not include weekends and non-working hours.
 
 
 
Time spent - total time spent on each task
durationFact - the actual duration of the task