Datasets contain information on workflows, SPA, employees, and other items. Each item has multiple datasets that automatically include both standard and custom fields. Use these datasets to create charts and analyze business performance indicators.

Datasets

To start analyzing data on a dashboard, select a dataset and create a chart based on it.

Workflow assignments — bizproc_task: Provides information on workflow assignments, such as their names, types, statuses, and execution times. Use it in charts to track assignment completion.

Workflows

Workflow — bizproc_workflow_state: Includes information on active workflows, such as their statuses, execution times, and details about the users who started or edited them. Use it in charts to track start times and workflow progress.

How to create a chart

Use datasets to create charts and track workflow execution. The charts can show active workflows and their stages.

Go to the BI Builder and follow these steps:

1. Open the Charts tab.
2. Click + Chart.
3. Select the dataset from the list. If you don't see the one you need, click Add a dataset to create a new one.
   How to create a dataset
4. Choose a format for showing the data: big number, table, line chart, or others.
5. Click Create new chart.

How to blend datasets

Combine datasets to include information about pending workflow assignments and their stages in the report.

Go to the BI Builder and do the following:

1. Go to SQL > SQL Lab.
2. Select the bitrix24 scheme.
3. Enter the SQL query and click Run.

The new set includes information from the fields that you specified in the SQL query. You can save it as a dataset to create a chart for the dashboard.
Create a chart based on a virtual dataset

If you're blending datasets for the first time, refer to the sample query.

SELECT
    bizproc_task.ID AS "Assignment ID",
    bizproc_task.NAME AS "Assignment name",
    bizproc_task.USER_NAME AS "Assignment participant name",
    bizproc_task.STATUS_NAME AS "Assignment status",
    bizproc_workflow_state.STARTED AS "Workflow start date and time",
    bizproc_workflow_state.STARTED_BY_NAME AS "User who started the workflow"
FROM
    bizproc_task
LEFT JOIN
    bizproc_workflow_state 
    ON bizproc_task.WORKFLOW_ID = bizproc_workflow_state.ID
WHERE
    bizproc_workflow_state.COMPLETED = 'N';